=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
|