Minute Addition

[Mel Lowe]

I have a problem adding minutes. I need to be able to add say, 17 mins, 25 mins and 45 mins and have the answer as 1 hr, 27 mins. How do I achieve this? I have looked in all the obvious formats, but none seems to help. I must have missed THE one that does it! - Please help!

[ This Message was edited by: Mel Lowe on 2002-05-14 09:32 ]

[Yogi Anand]

key in 0:17 in A1
key in 0:25 in A2
key in 0:45 in A3
in A4 ... =Sum(A1,A2,A3)

[Dave Patton]

If the entries are numbers such as 0:45

use a formula like =sum(c1:c3)

If the entries are text such as "45 minutes",
extract the number part in another column or use an array formula such as

=TIME(0,SUM((LEFT(C1:C3,2))+0),0)

Array enter with Ctrl-Shift-Enter (CSE) or

use =TIME(0,SUMPRODUCT((LEFT(C1:C3,2))+0),0)

My previous post was deleted.

[ This Message was edited by: Dave Patton on 2002-05-14 10:18 ]

[Al Chara]

....or

Assuming that your data is in cells A1:A3, in cell A4 place the following formula:
=SUM(A1:A3)/1440

Then format cell A4 as TIME. dividing by 1440 coverts the minutes into days. Excel treats all TIME as fractions of days.

Or, if you don't want to format A4 as time, then use the following formula instead of the above formula:
=TIME(0,SUM(A1:A3),0)

_________________
Hope this helps.
Kind regards, Al.

[ This Message was edited by: Al Chara on 2002-05-14 11:42 ]

[Mel Lowe]

Thanks - That gives me a few options.

[Barry Katcher]

Just as a matter of interest, all you woodworkers out there can do the same with fractions. Summing 1 7/8 (one-space-seven-slash-eight) and 2 1/2 returns 4 3/8.

And, if you look in the formula bar, you'll see the 1 7/8 entry shown as its decimal equivilent, 1.875.