How do I add hours and minutes eg 4.50 + 2.30 = 7.20
 

I want to add hours and minutes eg

Hours Minutes
4 50
2 30
Total 7 20

=SUMPRODUCT(--(TIMEVALUE(A1:A2&":"&B1:B2))*24
will give 7.33
where Col A holds hours and col B holds minutes

Now if you need it like 7 hours and 20 minutes then you will need another
formula something like this
Say the above result is on cell C1 then on cell C2 type

==INT(C1)&" Hours "&MOD(C1,1)*60&" Minutes"


"MichaelFAuty" wrote in message
...
I want to add hours and minutes eg

Hours Minutes
4 50
2 30
Total 7 20

Hi

Let you have hours in range B2:B3 and minutes in range C2:C3 (for your real
task you have to mofify those ranges)
The formula for total will be
=SUM(TIME(B2:B3;C2:C3;0))
entered as an array formula (Ctrl+Shift+Enter), and formatted in any valid
datetime format - I advice to use the format "[hh]:mm", which prevets hour's
rollover at 24h.
When entered properly, in formula field you see the formula as
{=SUM(TIME(B2:B3;C2:C3;0))}

--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets


"MichaelFAuty" wrote in message
...
I want to add hours and minutes eg

Hours Minutes
4 50
2 30
Total 7 20

Hi again

Sorry, but I forget to replace semicolons in formulas with commas - probably
you must do it!

--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets


"Arvi Laanemets" wrote in message
...
Hi

Let you have hours in range B2:B3 and minutes in range C2:C3 (for your
real
task you have to mofify those ranges)
The formula for total will be
=SUM(TIME(B2:B3;C2:C3;0))
entered as an array formula (Ctrl+Shift+Enter), and formatted in any valid
datetime format - I advice to use the format "[hh]:mm", which prevets
hour's
rollover at 24h.
When entered properly, in formula field you see the formula as
{=SUM(TIME(B2:B3;C2:C3;0))}

--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets


"MichaelFAuty" wrote in message
...
I want to add hours and minutes eg

Hours Minutes
4 50
2 30
Total 7 20