Converting Time Values

[YuGhee]

How to convert 326.03 minutes into this form __hr__min__ sec?

I am supposed to enter a formulae which works out the total time spent on all calls listed in a pohone bill.

If I am provided with a data of showing all minutes and another column showing all seconds, how do I calculate the total time spent in that form __hr__min__sec?
Pleas help.

 

[Aladin Akyurek]

Lets say that A1 houses the value "326.03 minutes".

In B1 enter: =HOUR(A1/1440)
In C1 enter: =MINUTE(A1/1440)
In D1 enter: =SECOND(A1/1440)

 

[Penfold]

...and following on from Aladin's post, if you needed them all neatly displayed in one cell you'd put the following in cell E1 (say):

=B1&" hr, "&C1&" min, "&D1&" sec"


Regards,

Penfold

 

[Mark W.]

If A1 contains 326.03 use...

=A1/1440

...and format as...

[h] "hr" m "min" s "sec"