Quote:
Originally Posted by Claus Busch
Hi,
Am Wed, 1 May 2013 14:51:02 +0100 schrieb AAFES:
I have been looking at it for most of the day, and still can't quite
figure out exactly how the formulas need to change to get it to
calculate correctly. I will probably continue to try and work on it.
in the new version, the formulas are already changed.
Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
|
For the second shift hours, in the spreadsheet if you were to plug in a start time of 9:00 and a lunch from 14:00-15:00 and a leave time of 21:00 it will spit out 7 hours regular first, 1 hour regular 2nd and 3 hours OT it should read out 8 hours regular first, (9:00-18:00 minus a 1 hour lunch is 8 hours) and 3 hours OT. I have started working out the other issues I had with the spreadsheet and the Maximums.