• Drivers Hours Software

Drivers Hours Software

Thanks for your formula suggestions on Wednesday's blog post about. Here's another formula example, and I'm sure you'll have alternate methods for this problem too. Driver LimitsIn some countries, there are limits to the hours that truck drivers can work in a string of consecutive days. In this example, the limit is 60 hours, in any period of 7 consecutive days.The maximum hours is entered in cell C1, and the number of consecutive days is entered in cell F1. If the regulations change, it will be easy to change those settings.Calculate the Remaining HoursTo help prevent drivers from going over their limits, we'll set up a table where the daily hours are entered.The date and driver name are entered in each row.