Time Representation
The time component of a serial value ranges in value from 0–0.99999999, and represents times from 0:00:00 (12:00:00 AM) to 23:59:59 (11:59:59 P.M.), respectively.
Going forward in time, the time component of a serial value increases by 1/86,400 each second.
Note: : As such, the time 12:00 has a serial value time component of 0.5.
example: