It would help if you told us what formulas you entered and how the calculation
was incorrect. Presumably you are doing this manually now, so I don't see that
it's very hard to get the calculations into Excel.

You have columns for Accrual rate Vac & Sick, but in your first post you say
3.08 and 1.54 hours per pay period. Are these accruals constant or variable?

Also, what are you trying to calculate? Vac taken and Sick taken?

The other thing that confuses me is surely you need to enter the hours worked in
a pay period, but maybe that's part of my misunderstanding.

I think the best way to get help is to give an example of a (fictitious)
employee's data, and what results you need.

--
Regards,
Fred


"Elaine" wrote in message
...
I am entering the current accrual total hours for vacation and sick for each
employee. I attemplted to create a sheet but all my numbers are not
calcuating correctly. My data fields are Name, Accural rate Vac, Accural rate
Sick, Current Vac, Current Sick, Old Vacation, Old SIck, Vac taken, Sick
taken.

All information is entered already. From payroll to payroll I change current
to old and Old to current and then enter current totals. From me entering
the new current sick and vacation that will determine what has been taken.
Statutory holidays and the unpaid are not a problem. I just want to verify
the accural and time off for the pay period.

Thank you very much for quick response.
Elaine

"Fred Smith" wrote:

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