Using Time in Formulas
Okay...now you are way tooooo much like me!!!! No Errata was needed :o) I
totally understood and I am delighted with the results and your help!!!!!!
Thanks again!
Cheri
" wrote:
Errata....
I wrote:
Cheri wrote:
We often get reports where the time is entered as 41:58:00 where the 41 is
hours, the 58 is minutes and the 00 is seconds.
[....] It is formatted as: CUSTOM [h]:mm:ss.
However, when you click on the cell, what you see in the formula line is
1/1/1900 5:58:00 PM
[....]
Time is stored as days since 1/1/1900, which explains the "funny" form
that you see in the fx (formula) field.
Poorly phrased. I meant to say that time is __interpreted__ as days
since 1/1/1900, just like a date serial numbers. But as I explained
further....
You can see the true form by
formatting as Number. So 41:58:00 is approximately the number 1.7486.
That is, time is __stored__ in days and fractional parts thereof.
|