View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Calculating hours

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



Thomas wrote:

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?
--
Thomas Jørgensen


--

Dave Peterson