We need more information. The trite response is to add 1.54 hours to sick leave
every period, and 3.08 hours to vacation. But I expect it's more complicated
than that.

What data are you entering? Hours worked every day? every pay period? What
happens with statutory holidays? How do you know when an employee is taking sick
leave, vacation leave or unpaid leave?


--
Regards,
Fred


"Elaine" wrote in message
...
I need to create a payroll spreadsheet to calculate time off and verify
accural.
Our employees work 8 hours a day and accrue 1.54 hour sick and 3.08 vacation
each pay period.

If I put in the current totals for sick and vacation how do I calulate to
compute time taken for ea pay period. Oh what would my formula be?

Thank you.
Elaine