Sick Time Accrual Formula

[KristiGohs81]

Hi Everyone!

I am looking to create a formula that will calculate the paid sick time. I have created a spread sheet that has each pay week, employee and the hours they worked for that week. I would like it to automatically calculate how many hours the employee has earned. (For every 30 hours they earn 1 hour paid sick leave). Can anyone help me out with this?

THANKS IN ADVANCE!!!

 

[Fluff]

How about

=ROUNDDOWN(SUM(C2:BB2)/30,0)

 

[EXCEL MAX]

Hello Kristigohs81,
put this formula in the cell BC2.
=(SUM(C2:BB2)-MOD(SUM(C2:BB2),30))/30*$BE$2+MOD(SUM(C2:BB2),30)/3
Put in the cell BE2 hourly price.