Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
=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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding hours and minutes | Excel Worksheet Functions | |||
convert hours and minutes to minutes | Excel Discussion (Misc queries) | |||
add column of minutes, show total in hours & minutes | Excel Worksheet Functions | |||
How do I convert times from hours to minutes? | Excel Discussion (Misc queries) | |||
calculate average hours and minutes | Excel Worksheet Functions |