Change Days to Hours on a Template

[ryfiphone]

Good afternoon everyone. I found a fantastic template for tracking time off for employees, but it is created to track days taken and not hours. I wanted to change this but the formulas are way beyond my excel ability. I was wondering if anyone has the time to take a look and see if this can be done? I created a section below the "taken" section where I wanted to incrementally reduce their hourly bucket based on the data in the "Employee Leave Tracker" tab. I was going to include annual bucket amounts in the "Settings" tab as I dont necessarily need a look back comparison year over year. Let me know what you think? I really appreciate it.

[Tsjallie]

Added a formula to calculate the Vacation Balance and added a column to the Employees Table for the bucket.
Would that be what you're looking for. I think you can just enter numbers as hours, so no need for conversion from days. Unless you want to show hours instead of days in the calender.

[JeanneJo]

Thank you so much! I was looking at this very template, wanting to accommodate it to keep track of sick, personal and vacation leave for staff in this Firm. Your spot on advice allowed me to adapt this great template for our needs. Love the template, and am so glad with your excellent advice that I can use it, with minimal tweaking.