Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a productivity workbook which has 19 pages, I am trying to summarise
two of the final figures & the time is showing as 99:35:00 even though I know it should in fact only be 27 hours 40 mins, i have tried everything to sort this & cannot see where I am going wrong. On each page I have a total time worked & a total time used giving a monthly productivity percentage. I tried to sum the first to the last page & it has worked for most figures except these times. Can anyone help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formatt date from text | Excel Worksheet Functions | |||
Formatt cell | New Users to Excel | |||
Today() ... Month() ... Formatt mmm | Excel Discussion (Misc queries) | |||
How do I add a zero in front of a text formatt number? | Excel Worksheet Functions | |||
Time formatt | Excel Discussion (Misc queries) |