Forum Discussion
IF Function - Formula Help
I am trying to create a formula to track hours of service for drivers. The driver is only allowed to work 70 hours continuously. The Driving column and the on duty column have to be subtracted from H...
Hi Sharlene
How about the attached
Thank you for the response. That kind of works, would you be able to help me fix the formulas a bit. For the Comm. Off Duty column, i still need it to recognize when a driver has been working. So if there is hours worked, the Cumm. Off Duty would be, 24 - hours worked, (highlighted cells in green). Also when the driver has had 36 consecutive hours off, then the HOS column would reset to 70 (highlighted in purple). The Hours Worked column would calculate a cumulative total, until the 36 hours off was reached and then it would reset (highlighted in grey) to zero.