Mins and Hours totals not working properly

  • Thread starter Thread starter Brandon
  • Start date Start date
B

Brandon

This is driving me mad. I need to add up rows of hours
ie 2:30 for 2 1/2 hours. I have set the format as this:
02:30:00
I have set a sum formula for the total to be added up as
this:
=SUM(F3:F132)
The problem is that when the hours go over 24, it starts
to count again from zero. I get 3:30 instead of 27:30.
Any ideas please.
KR
Brandon
..
 
Hi Brandon!

Format the sum cell:

[hh]:mm

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Hi Brandon

Format the result cell custom format
[hh]:mm
or see if you have a time format labelled as something like
37:30:55
if so you can use that.
 
One way:

Format/Cells/Number/Custom [h]:mm

the brackets keep the time from "rolling over".
 
Thank you all for your help.
KR
Brandon
-----Original Message-----
One way:

Format/Cells/Number/Custom [h]:mm

the brackets keep the time from "rolling over".

Brandon said:
This is driving me mad. I need to add up rows of hours
ie 2:30 for 2 1/2 hours. I have set the format as this:
02:30:00
I have set a sum formula for the total to be added up as
this:
=SUM(F3:F132)
The problem is that when the hours go over 24, it starts
to count again from zero. I get 3:30 instead of 27:30.
Any ideas please.
KR
Brandon
.
Click to expand...
.
Click to expand...
 
Back
Top