Kimston
01-18-2013, 09:34 PM
I’ve created an excel file where I can track vacation days or vacation hours taken by an employee. However, I’d like to know if there is a way to deduct partial hours taken by an employee from a specific date or date range excluding weekends and holidays. For instance an employee may opt to take 4 hours of vacation instead of the 8 hours. In the Accrual Balance and Vacation Records Excel file, there is a tab named “Vacation_Records” in which contains a column named “HoursTaken”. I'm able to count days taken by an employee from a date or date range excluding weekends and holidays, but is there a formula to simply deduct partial hours?
Right now the only way I can deduct hours in HoursTaken column would be by typing the value. Since I have not received any responses in another forum, I decided to post it here.
Again thank you very much for your time and dedication.
Right now the only way I can deduct hours in HoursTaken column would be by typing the value. Since I have not received any responses in another forum, I decided to post it here.
Again thank you very much for your time and dedication.