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
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