Hour function equivelent help
If you want to see your 56:46:32, but it is displaying as 08:46:32, change
the formatting from hh:mm:ss to [hh]:mm:ss
If you want to turn 56:46:32 to hours, multiply by 24 and format as General
or Number.
If you want to turn 56:46:32 to minutes, multiply by 24*60 and format as
General or Number.
--
David Biddulph
"EAB1977" wrote in message
...
If I want to find out how many minutes there are for times that I have
summed, I know I can use the hour function if the compiled time is
less than 24 hours. But, what if I want to get the times that are over
a 24 hour period, how do I do that?
Example:
20:57:46
14:39:10
8:57:24
12:12:12
-------------
56:46:32 -- the minutes I'd like to get
|