Dates in excel curiouser and curiouser

  • Thread starter Thread starter DannyJ
  • Start date Start date
D

DannyJ

Hi folks,

I am creating a time sheet but there are some strange problems, notably it
calculates the time fine until thw total is over 24 hours and for some
reason the minutes are getting rounded up despite there being 2 decimal
places...eg 6 minutes becomes hh:10. Very odd and any help would be
appreciated

Cells are formated as hh:mm. Formulae are either a)
(Start Time - End time )-(Lunch End-Lunch start)

or sum((End Time - Lunch end)*24,(lunch start-start time)*24))

Many thanks,

Danny
 
Sounds like a problem with the time format. Something like hh:00 instead of
hh:mm. Can you check the format of the cells? Format-->Cells, Number tab...
*******************
~Anne Troy

www.OfficeArticles.com
 
Back
Top