Thread: Adding time
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
smiley61799 smiley61799 is offline
external usenet poster
 
Posts: 17
Default Adding time

I am trying to add time and I am having some difficulties finding a way to
format my numbers to be on a time scale. Example:

John worked
Monday 8.02
Tuesday 8.0
Wednesday 8.54
Thursday 8.09
Friday 7.59

This would total to 41.04 hours for the week but if I try to add this on
Excel it is using the number scale of 100 instead of a time scale of 60 so I
am getting a total of 40.24. Is there any way to format this to add it
correctly??