Help creating sick time accural calculator tracker

I see a few posts about this topic but I still need help. I need a excel document that tracks sick time for several employees. Parameters: employees accrue one hour of sick time for every 30 hours of work performed, up to a maximum of 40 hours per year. I pay my employees monthly.

Any help is appreciated

.
It is a matter of multiplication ... but have you looked around the internet to see what templates exist that would be useful for your business ?

Tracking time worked / sick time / vacation time / etc. is a popular topic with Excel. Once you settle on a format and present the design here,
it shouldn't take long to finalize it.

Ok here is my tracking sheet but I am not sure it is tracking the hours earned correctly. Portland, Oregon law states that employees receive 1 hour per every 30 hours worked. We can cap each employees earned hours to 40 hours per year and also not allow them to roll over to the next year. Please look at my sheet and tell me if my calculations are correct.

I so appreciate your help.

wendi

Thank you so much!! I really appreciate your help.

Wendi

I do have one more question now that I am working in the sheet. How can I make each employees balance start at zero each year on their anniversary date? Would I manually override the formula in the balance column? Each employee has a different month for their anniversary date too.

I used to be able to enter thier start date in the top and it would calulate the dates down the left side for me but I deleted on accident.

Wendi

Oops also one more thing. When I enter numbers in the used column it does not subtract it from the balance.

I do not think the balance column is working correctly

I figured out what its doing. It is resetting the amount accrued on December. Each employees reset date is different though. sorry for all the messages.

I uploaded an example so you can see