I'm designing a time card,and at my wits end,and I need a little help.and only need one more formula.I'll use A as representing the first 2 wks,B as the 2nd 2wks and so on.Just as a reference.
What I need is a formula,that can calculated time over 80 hrs for a 2 wk period an able to carry it over to the next pay period.In one column I have my hrs worked.I need to keep track of my ot hrs,while at same time keeping my worked hrs at 80,if the worked hrs fall below 80 ,I would like to take it from the ot hrs and = to 80,and to be able to subtract the amount from the ot hrs and keep a running amount.