Adding up hours and minutes
Hi Dave,
What seems to be happening is that the sum of the hours and minutes (29 hrs
36 mins) is being converted back to the remainder after being divided by 24
hours (29:36 - 24).
One way round this could be to convert the times to minutes, e.g.
=HOUR(a1)*60+MINUTE(a1) ' where a1 etc. contain 7:24, giving 444 minutes in
total (using number as the cell format instead of hh:mm)
Adding the minutes and dividing by 60 gives 29.6, which can be converted
back to 29:36
HTH
Anthony
"Dave" wrote:
Hi,
I need to add up a list of hour and minutes, the only problem being is that
Excel treats them as TIME not hours and minutes.
For example, if I sum 7:24, 7:24 , 7:24, 7:24 [ where 7 = hours and 24 =
minutes ] then Excel five me an answer of 05:36 rather than 29.36 - any ideas
how I get this working ?
Thanks
|