8.0) rather than hours being calculated based on start- and end-times. You enter the number of hours worked (e.g.This is our most simple, no-frills type of timesheet.
The effective date of the Final Rule was February 27, 2012, and the compliance date of remaining provisions was July 1, 2013.Ĭan anyone help me or point me in the right direction? Thanks, Leon Lovett.ĭriver Timesheet Features of this spreadsheet: The Hours of Service of Drivers Final Rule was published in the Federal Register on December 27, 2011. Long daily and weekly hours are associated with an. Then the next day there would be another number at the bottom, so there would be 4 numbers to add before reaching the zero.ĭepartment of Transportation. So, if C4 through C11 have the following values: 11 12 10 13 0 12 13 11 it would only add 11,13, and 12.
This database will be updated daily, so it will be constantly changing. I have it all figured out except for the following: I need to sum back 8 cells up in the column until it reaches a cell with a zero in it. I have spent two days now trying to figure out a way to make a spreadsheet to do what I need to do.
