![hours calculator excel template hours calculator excel template](https://www.automateexcel.com/excel/wp-content/uploads/2020/12/calculate-hours-worked-Google-Function.jpg)
![hours calculator excel template hours calculator excel template](http://images.sampletemplates.com/wp-content/uploads/2015/03/Employee-Timesheet-Excel-Template1.jpg)
Available Balance changes with hours accrued and hours taken, as well as being affected by hours lost (not used within 6 weeks) Any TOIL not used within 6 weeks of the "Date Worked" is lost. I'm not looking for a formula for automatically logging TOIL after 39 hours, as we log our TOIL manually in hours worked (B4). We manually type in hours worked along with the date worked. We accrue 1.5 hours for ever hour worked over 39 hours. I am looking to use the same method but digitize and automate. It has always been done on paper, manually. I'm currently trying to make a TOIL timesheet for employees.