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".
|