Share via

PTO Excel Spreadsheet

Anonymous
2022-06-06T20:31:05+00:00

I carried over 40 from the previous year and accrue 8.615385 every 2 weeks.

I have :

but I need the formula to keep it calculating till the end of the year.

Pay Period Begin Pay Period End PTO Taken Grant per Pay Period Total PTO Remaining*
3/13/2022 3/26/2022 13 8.615385 87.307695
Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-06-06T21:41:50+00:00

    I carried over 40 from the previous year and accrue 8.615385 every 2 weeks.

    but I need the formula to keep it calculating till the end of the year.

    Pay Period Begin Pay Period End PTO Taken Grant per Pay Period Total PTO Remaining*
    3/13/2022 3/26/2022 13 8.615385 87.307695

    '---

    Nothing Left to Lose

    https://1drv.ms/u/s!Au8Lyt79SOuhZw2MCH7_7MuLj04?e=sAwbHU

    (free excel programs)

    Was this answer helpful?

    0 comments