Sick leave accrual

FPNWOPS

New Member
Joined
Dec 14, 2017
Messages
8
Hello.

I need assistance building a simple spreadsheet to track sick leave that has a 1 hour for every 40 worked accrual rate. This needs to be a rolling balance set-up so if a PT employee works 25 hours one week and 30 the next, the accrual will be triggered by the 40 hour mark and start the next 40 hour clock with the remaining 15 hours of that 2 week example. The time can be used in 1/4 hour increments and a balance has to be shown to the employee monthly. We pay once a month for hours worked and can track the sick leave hours in line with that period structure.

Thanks.

JC
 

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.
Not much. I am brand new to this whole forum thing and not sure how to share what I have. A screen snip doesn't help much. I have one but cannot figure out how to paste it in (it's not a URL)
 
Upvote 0
So no one has knowledge of an time accrual/ use formulas or help for this? If not, perhaps can advice where to look. Thanks.
 
Upvote 0
I don't think anyone will jump in without you at the very least posting how your data is laid out.
See my signature block below for some links to addins so that you can post usable screenshots on the forum.
 
Upvote 0
Date HiredPeriod End DateHours workedBal not = 40 muiltipleVac hrs accruedSick leave hrs accruedVac hrs usedSick leave hrs usedVac hrs balanceSick leave hrs balance
30-May1/31/201810002.581-81.5
2/28/201812034.5
3/31/20181303.257.75
4/30/2018120310.75
5/31/2018010.75
6/30/2018010.75
7/31/2018010.75
8/31/2018010.75
9/30/2018010.75
10/31/2018010.75
11/30/2018010.75
12/31/2018010.75
*eligble for sick leave after 90th calendar day from hire date.
Accrual rate is 1 hour for each 40 hours worked; (excludes vacation, holiday or other paid hours such as cash out)

<colgroup><col><col><col><col><col><col span="9"></colgroup><tbody>
</tbody>
 
Upvote 0
Thanks. I used the MrExcel HTML one and it allowed me to copy/ paste, but the post was not made. Not sure if it was kicked out, but it was on screen and said it would be reviewed
 
Upvote 0
That is just because you are a new member, a moderator will be reviewing it and then will post it. It is part of the anti-spam measures.
 
Upvote 0
I have reviewed and approved it (so you can see it now above).
 
Last edited:
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,211
Members
448,554
Latest member
Gleisner2

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top