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

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

"dindigul" wrote:

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

In article <en#(E-Mail Removed)>, "dindigul" <(E-Mail Removed)> wrote:
>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

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