Tracking PTO by hours worked

**Lola May** · 02-25-2015, 02:23 PM

Hello!

First time posting to a forum ever so this is exciting! I need to create a spreadsheet that will calculate PTO earned & spent. I've got about 7 full time employees & 1 part timer. The full timers earn 1 hour of PTO for every 40 hours worked & part timers gets 1 hr for every 20 hrs. In my perfect world of spreadsheets, the spreadsheet would go pay period (weekly) -- I would be able to enter the pay date, the amount of hours paid that period, once the employee hits the 40 hrs worked (whether it takes 2 weeks or 1) than it would add an hour to their total & start the count over. I have tried a couple different options; just cant seem to get it.

At the end of the year, the employees who did not use their PTO will be issued a check & starts at zero with the new year.

I appreciate any & all help!

Thanks!

**FlameRetired** · 02-25-2015, 03:34 PM

Lola May,

Welcome to the Forum.

Sounds like an intriguing assignment.

It would help if you would upload an example Excel workbook. Please do not post pictures.

Many of us cannot download / read these and none of us want to retype data. Hand type enough data to get

the idea across and the layout you envision with expected results. Include any additional details in the workbook.

Edit: I forgot to include instructions on how to do this....my apologies.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"