Add up a column of hours

  • 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,


= Int( 24*mySum) & Format( mySum, ":nn:ss")


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top