Calculating hours

T

Thomas

I am trying to register my working hours, but when I try to add up a column
of hours it only adds up correctly if the total is less than 24 hours.

How do I correct this?
 
D

Dave Peterson

Are you really adding times...

Maybe it's adding correctly, but not displaying what you want.

Try changing the number format for that cell to:
[hh]:mm:ss
 

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

Top