Thread: Time Cycle
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Stephen[_2_] Stephen[_2_] is offline
external usenet poster
 
Posts: 364
Default Time Cycle

"Antonio" wrote in message
...
Morning all

Need to calculate time cycles, can anyone help??

Tks in advance


In Excel, dates are stored as number of days since 31st Dec 1899 (that is,
one day =1). So, for example, today (3rd Dec 2007) is 39419. Time is just
the fractional part of these numbers. 6:00am is quarter of the way through
the day, so 6:00am this morning is 39419.25. Formatting just displays these
numbers in a conventional date/time format. But once you understand the
underlying numbers, you can calculate with them as you wish. If you still
need help, please explain what you mean by "time cycles".