Anne this is brilliant, your the headache tablet ive been looking for,
but I have a question ? is it possible to just type in the times in
Start and Finish without putting the date in, This timesheet is
designed for night shift work only so I will always start one day and
finish the next. Also there is one more problem thats bugging me and
that is if you look at cell U28, this is whats left of 48 hours POA in
a week, the law says that a driver of a HGV cannot exceed 48 hours POA
in a week and needs to know whats left. Cell L23 is the total POA of
the week so I need to take this figure away from 48:00, all I get is
#######.


--
Chris Watson
------------------------------------------------------------------------
Chris Watson's Profile: http://www.excelforum.com/member.php...fo&userid=4700
View this thread: http://www.excelforum.com/showthread...hreadid=511313