Posted by Chris on December 18, 2001 5:09 PM
I am trying to automate our hospitals timesheet.
I have the simple stuff done. Hrs worked, OT, Subracting vacation hours used.
I have a running total on vacation hours
Ex: I have a total of 10 hrs vacation time. I get paid twice a month and get 5 hrs on each payperiod.
So I used 8 hrs in the first payperiod.
I know how I would 10-8 but how do I have the sheet add 5 hrs at the end of each payperiod?
And how do I have the sheep NOT add 5 hrs if the person had "Leave Without Pay"
Thanks for your help