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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mins and Hours totals not working properly 4
Calculating hours on a timeclock form 7
Sum Hours over 24 hours in Access Report 0
URGENT - How to convert this decimal values into hours? 2
Add Hours by Looping through Data Q 27
Sum number range ignoring numbers formatted as text 0
How do I sum a daily hour total by week? 3
Adding Time in Excel - Frustating experience!! 5

Back
Top