Thread: time formatt
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Liana Liana is offline
external usenet poster
 
Posts: 19
Default time formatt

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