HelpExcelHelpers
New Member
- Joined
- May 5, 2018
- Messages
- 15
Hi there!
I was wondering if there is a formula to automatically calculate paid time off per pay period based on a starting date and amount. Each pay period (every 2 weeks on a Thursday) would be 6.1538 hours.
Example:
May 24 (Thurs) start with 70.1538 and every 2 weeks, June 7 (Thurs) is another 6.1538 hours added to the total automatically.
I was wondering if there is a formula to automatically calculate paid time off per pay period based on a starting date and amount. Each pay period (every 2 weeks on a Thursday) would be 6.1538 hours.
Example:
May 24 (Thurs) start with 70.1538 and every 2 weeks, June 7 (Thurs) is another 6.1538 hours added to the total automatically.