Forum Discussion
Trucker's logbook recap in Excel
Here are my last 8 days of hours:
7/26 8:44, 7/27 7:26, 7/28 11:14, 7/29 8:12, 7/30 6:42, 7/31 10:30, 8/1 10:51, 8/2 0:00. What I need is a spreadsheet where I can enter the current day's hrs/mins and the spreadsheet will add all the hrs/mins up, then subtract the oldest day's hrs/mins then subtract that total from 70 hrs. It needs to roll the oldest day off. If I can get that much done, then I'll try to figure out how to make it consider the 34 hour restart rule. Everything I know about Excel is self-taught and these are complex formulae that are way past my abilities. Thanks so much for helping!
Here and attached is mock-up
In first column you manually put any symbol into the cell for the first date of the period. Next two columns are date and time. Next is cumulative time in the period like
=IF(ISBLANK(B5),N(E4)+D5,D5)
and the last column shows how much time do you have till end of the period.
If you have some rule how to shift from one period to another you most probably don't need first and last column using the formula for the rule in calculating cumulative time in the period.
I am a truck driver also and downloaded the example file for tracking hour of service. It is fantastic!!! Thank you!
Ptgizmo , you are welcome, glad to help
Has there been any update for The 70 hour clock and to count the 8th day recap? SergeiBaklan
