How come value("16:48:00" -value("12:00:00") is 4:48?

D

dindigul

16:48 also means 4:48, 12 noon means 0.5 and in evaluate it shows 0.7 - 0.5
= 0.2, and it shows 4:48. Can anyone explain? Thanks
 
B

Billy Liddel

Dindigul

00:48 as a fraction of a day = 48 / (60*24) = 48/1440 = 0.033333333
4:00 as a fraction of a day is 4/24 = 0.166666667

Therefore, 4:48 = .0333 recurring + .1667 = .2 (of a day.

Regards
Peter
 
B

Bruce Sinclair

16:48 also means 4:48, 12 noon means 0.5 and in evaluate it shows 0.7 - 0.5
= 0.2, and it shows 4:48. Can anyone explain? Thanks
Click to expand...

Your cell is formatted to show time ? If that is so, the answers make pefect
sense :)
 
Top