Time to number formatting

[ChrisRitchie]

I have changed the time value 792:43:12 to a number value (33.03000). How does Excel calculate the time value from the number value?



<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>

 

[pgc01]

Hi

The day is the datetime unit in excel, so you have 33 days + 0.03 of a day