Converting Time Values

YuGhee · Apr 21st, 2002, 10:19 PM

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 · Apr 21st, 2002, 11:08 PM

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 · Apr 21st, 2002, 11:33 PM

...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. · Apr 22nd, 2002, 07:51 AM

If A1 contains 326.03 use...

=A1/1440

...and format as...

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 21st, 2002, 10:19 PM	#1
YuGhee New Member Join Date: Apr 2002 Posts: 1	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.

Apr 21st, 2002, 11:08 PM	#2
Aladin Akyurek MrExcel MVP Join Date: Feb 2002 Location: The Hague Posts: 50,317	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)

Apr 21st, 2002, 11:33 PM	#3
Penfold New Member Join Date: Mar 2002 Location: Australia Posts: 43	...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

Apr 22nd, 2002, 07:51 AM	#4
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	If A1 contains 326.03 use... =A1/1440 ...and format as... [h] "hr" m "min" s "sec"