L.2.16.9.2 Time Conversion for Serial Values

The time component of a serial value ranges in value from 0–0.99999999, and represents times from the instant starting 0:00:00 (12:00:00 AM) to the last instant of 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. (As such, the time 12:00 has a serial value time component of 0.5.)

The serial value 0.0000000… represents 00:00:00 The serial value 0.0000115… represents 00:00:01 The serial value 0.4207639… represents 10:05:54 The serial value 0.5000000… represents 12:00:00 The serial value 0.9999884… represents 23:59:59