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
|