Forum Discussion

DUKETRAC's avatar
DUKETRAC
Copper Contributor
May 11, 2022

Need help with excel formulas!

I am using the excel spreadsheet employee attendance.

I am also using Microsoft Office version Version : 18.2110.13110.0

I am trying to add one hour per month for PTO (personal time off) and cap out at 12 hours.

I know the formula I am using isn't right, but was trying to make it work. lol 
Plus add yearly vacation time, but I would like it to begin on the employees anniversary day.  I am no pro at excel, but was trying different formulas.

https://apextrailernet-my.sharepoint.com/:x:/g/personal/rduke_apextrailer_net/ETfChOaXLSlGqqMpjvE78uUBfqAPzrqriEGJIQl-bxJsvw?e=cdfj9k 

Thanks for any and all help that I can get.

1 Reply

Resources