On Thu, 2 May 2013 03:00:16 +0100, AAFES
wrote:
Claus Busch;1611539 Wrote:
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.
+-------------------------------------------------------------------+
+-------------------------------------------------------------------+
If someone has to sit at a machine and have "a session" for entering
their time, it is no harder to have them make more than one entry.
So, if you make (force) morning period, a lunch period, and an
afternoon period (use 'early' and 'late' period for other shifts), you
will be able to segregate the lunch period. Since you said that they
vary, this would be ideal.
Then you could perform your math on these grouped subtotals and
simplify the workbook's operations.
So the person would have to enter their morning time and their lunch
and their afternoon time. No big deal to make a couple additional
entries while you are already sitting at the machine.
I have a simplified time accrual only sheet which you may get ideas or
styles or formatting from. Use as you wish.
It does no OT calculations. Again, it is simply accrual based, and
reports total hours for given jobs. Give it a look...
Check out the time incrementing 'feature' for data entry use.
http://www.mediafire.com/view/?8atcc048a4dfndt