Thread: Convert date/time to serial number and compare serial numbers
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
GARYWC GARYWC is offline
external usenet poster
  
Posts: 80
Default Convert date/time to serial number and compare serial numbers
I suppose "serial date-time" is the correct term.

The serial date-time is the number of days since 1900-Jan-0, plus a fractional portion of a 24 hour day.

Its format of the serial date-time is: ddddd.tttttt
Reply With QuoteReply With Quote