Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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?? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Adding Time | Excel Worksheet Functions | |||
Time log adding time from separate sheets | New Users to Excel | |||
Adding Time | Excel Worksheet Functions | |||
Adding Time | Excel Worksheet Functions | |||
Adding time to date-time formatted cell | Excel Discussion (Misc queries) |