Hour Sum

  • Thread starter Thread starter Vic1978
  • Start date Start date
V

Vic1978

Hello,

How is it possible to make a sum of hours?
I just the format 09:45 and wanted to sum several cells. The result is
that after 24 hours the sum starts at 0 again.
Which kind of formula could I use for the sum of hours?

Thanks a lot
Vick
 
Format the cell with [h]:ss
The square brackets prevent mod 24 arithmetic
best wishes
 
Hello,

How is it possible to make a sum of hours?
I just the format 09:45 and wanted to sum several cells. The result is,
that after 24 hours the sum starts at 0 again.
Which kind of formula could I use for the sum of hours?

Thanks a lot
Vicky
Click to expand...

Same formula. But to keep the hours display from "rolling over" at 24, format
the cell where you have your SUM formula as [h]:mm The brackets keep the 24 hr
hour rollover from occurring.


--ron
 
You must log in or register to reply here.

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

Adding Days and Hours 8
Hours and sum of hours 2
Adding Times 7
Need help adding hours exceeding 24 hours 7
Adding up total hours worked on employee schedule using various criteria 0
Using SUM function to count hours BUT ignore Letters? 6
Adding Hours Worked Correctly 3
Sum a column 2

Back
Top