sick days

  1. H

    Monitoring sick pay over a rolling 12 month period - with two levels of pay

    Hi All I've been staring at this for two days and I'm stuck, hope you can help me. The company I work for looks at sickness for a rolling 12 month period. In that period, we pay 100% pay for the first 65 days of absence, 50% pay for the subsequent 65 days of absence, and then 0 after that...
    • HRJon
    • Thread
    • absence periods pay calculation sick days sickness tracker
    • Replies: 4
    • Forum: Excel Questions
  2. zakasnak

    government sick leave calc/formula

    Hello! It's been awhile..... I am looking for formulas to figure out months & days from sick leave accumulated to count toward retirement. At retirement age, providing I'm not ever sick between now & then, I will have 1342 hours of accumulated sick leave. Anything over a year (2087 hours) is...
  3. D

    Overtime formula

    Hello. I'm trying to create a time sheet that tallies overtime hours after 40 hours worked, with sick time, vacation and holidays, where none of these can put one into overtime. if anyone can help me with this formula, or knows of an existing template, it would be greatly appreciated! Thank you.

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