formula to count in hours/mins

[imported_unknown]

needing a formula to sum up hours but not roll over into counting days ~ if total is 38:18 (38 hours, 18 minutes) i need it to say that, NOT 1:14:18 or 1 day, 14 hours, 18 min.

***********

 

[cocacola]

i have a canned formula that looks like:

=(L9-L30)/(144/24)

to what does the 144 refer?

 

[Mark W.]

On 2002-12-18 10:02, cocacola wrote:
i have a canned formula that looks like:

=(L9-L30)/(144/24)

to what does the 144 refer?

I don't know. Could it be a typo? There are 1440 minutes in day. So 1440/24 yields the number of minutes in an hour, 60.
This message was edited by Mark W. on 2002-12-18 10:19