Dates in excel curiouser and curiouser

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
 
A

Anne Troy

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
 
Top