Thread
:
Time Calculations Help
View Single Post
#
5
Posted to microsoft.public.excel.programming
joeu2004[_2_]
external usenet poster
Posts: 829
Time Calculations Help
Errata.... I wrote:
=(TEXT(B1,"00\:00")-TEXT(A1,"00\:00"))*24
formatted as Number. Of course, that returns 10.5, not 9.5, with the
example times of 1330 and 2300.
Brain fart! The formula is right, and it returns 9.5, not 10.5.
Reply With Quote
joeu2004[_2_]
View Public Profile
Find all posts by joeu2004[_2_]