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