Posted to microsoft.public.excel.misc
|
|
time formatt
Please give more details
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"Liana" wrote in message
...
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
|