the current spreadsheet calculates the hole day less lunchbreak and
gives you total time taken for lunch and total time for the day in the
total at the bottom of the page gives the total for the F/N but the max
hours for the F/N is 70 Hours any thing over that is TOIL but management
want the times spelled out in a separate column to the rest with start
and finish times.

please if you need any more info please email me or reply to this post
my email is
Regards,
Jesse


--
Jesse_Norris
------------------------------------------------------------------------
Jesse_Norris's Profile: http://www.excelforum.com/member.php...o&userid=25546
View this thread: http://www.excelforum.com/showthread...hreadid=390465