# Sick Time Accrual Formula

#### KristiGohs81

##### New Member
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?

### Excel Facts

If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

#### Fluff

##### MrExcel MVP, Moderator
Excel Formula:
``=ROUNDDOWN(SUM(C2:BB2)/30,0)``

#### EXCEL MAX

##### Well-known Member
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.

Replies
16
Views
214
Replies
8
Views
410
Replies
3
Views
141
Replies
1
Views
488
Replies
3
Views
170

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,152,482
Messages
5,770,349
Members
425,612
Latest member
martinijr

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back