Drivers Hours Spreadsheet

Anyone like to share their particular methods or tips for keeping legal and monitoring theirDrivers Hours and WTD rules?It seems ( To me anyway! ) that Tachograph and ROG are both quite conversant and expertin all things tachograph and hours related. But are there other drivers that would claimto be 'On the ball' on these matters?I thought it would make an interesting topic, and would be helpful for newbies coming intothe industry, and oldies like myself, thinking of returning after 7 years away from haulageand trying to get my head around it all again!So what are your preferred methods. Big timer, Diaries?

Have you found or created anexcel spreadsheet that does the various calculations for you? Do you NEVER get anyInfringements with your ways of record keeping?How about sharing your tricks, tips or thought processes on how you deal with the thornyissue of Drivers Hours and WTD on a daily basis?

SENIOR MEMBER Posts: 238 Joined: Mon Nov 15, 2010 9:29 pm Location: West Sussex. ROG wrote:As the driver you do not need to keep track of your weekly/reference period WTD hours because that is on the employer(s) to doYou just need to present the company with the records such as downloading digi-cardMy reason for keeping a diary is for my own use, so many employers it seems from the horror stories I have read about on here are only too willing to simply give you an infringement from their record keeping and from their requests of pushing.

A diary gives you the knowledge and power to say no to those requests. A decent firm and there is no need for a driver to keep a record of WTD. Peirre wrote:If your capable of using an excel spreadsheet, or able to construct a rudimentary one for your needs from scratch then go for it.

Track Employee Hours Spreadsheet

I've done it in the past and maintained one keeping records for several years, it calculated total hours, average hours, wtd hrs, mileage, annual mileage, and if I imputed start/finish times & hrs worked it calcated gross & net wages and more, but in the end it was a waste of my timeI spent hours on a spreadsheet to print out time sheets for the agency. It all worked fine until I started doing nights and I could never get the hours right across a midnight. I gave up in the end and carried on doing them manually. Tachograph wrote:As far as I'm aware the driver is as responsible as the company for making sure he/she complies with the RT(WT)R.Reading the rules they do not expect drivers to have a PC programme to keep track of the average 48 and the Tacho is not designed to keep track of the weekly max which is why it is the responsibility of the employer to do that in the admin deptWhere in the regulations does it say, or even insinuate, that a driver has no responsibility for complying with any particular part of the RT(WT)R. Peirre wrote:If your capable of using an excel spreadsheet, or able to construct a rudimentary one for your needs from scratch then go for it. I've done it in the past and maintained one keeping records for several years, it calculated total hours, average hours, wtd hrs, mileage, annual mileage, and if I imputed start/finish times & hrs worked it calcated gross & net wages and more, but in the end it was a waste of my timeI spent hours on a spreadsheet to print out time sheets for the agency.

It all worked fine until I started doing nights and I could never get the hours right across a midnight. I gave up in the end and carried on doing them manually.i spent weeks building one, most of it was looking for formulas like this=IF(E3F3,F3+1-E3,F3-E3) formula for total hours cellE3 is start timeF3 is finish timeG3 is your total hours. 205 wrote:i spent weeks building one, most of it was looking for formulas like this=IF(E3F3,F3+1-E3,F3-E3) formula for total hours cellE3 is start timeF3 is finish timeG3 is your total hoursBe interesting to know how accurate and comprehensive that sheet is! For example, the need to attribute instances of extended driving time to fixed weeks, whereas instances of reduced daily rests are attributed to a rolling period which begins with the end of the latest weekly rest which precedes the daily rest in question (and the need to differentiate between reduced daily rest and split daily rest) makes the logic absurdly complex.Edit, thinking more about this.It also strikes me that there are ambiguities in the rules - for example, if an instance of extended driving time straddles two fixed weeks (i.e.

Ignoring the need for driving breaks, driving begins on Sun, 2017-07-30 at 1900, and finishes on Mon, 2017-07-31 at 0500, a cumulative driving time of 10 hours in total), then to which fixed week is the extension attributed for the purpose of counting whether the two-extensions-per-week limit has been reached?Also, most drivers aren't interested in knowing at the end of each day whether they have been compliant.Most drivers want to know 'will I be compliant?' , based on a proposal to do work (so a non-compliant proposal can be rejected or revised before a violation actually occurs).

Drivers Hours Spreadsheet Template

It's a hell of challenge to build a computer calculator for this kind of question!Personally, I just work on paper, and take a risk-based approach to monitoring the different limits, initially using rules of thumb. So for example, if my weekly rests always take place on weekends, and I haven't used either of the driving time extensions since my last weekly rest, then I don't need to even begin applying a complex system of calculation which can accurately determine, under all possible circumstances, whether I have one or zero extensions remaining within that fixed week! Peirre wrote:If your capable of using an excel spreadsheet, or able to construct a rudimentary one for your needs from scratch then go for it. I've done it in the past and maintained one keeping records for several years, it calculated total hours, average hours, wtd hrs, mileage, annual mileage, and if I imputed start/finish times & hrs worked it calcated gross & net wages and more, but in the end it was a waste of my timeI spent hours on a spreadsheet to print out time sheets for the agency. It all worked fine until I started doing nights and I could never get the hours right across a midnight.

I gave up in the end and carried on doing them manually.i spent weeks building one, most of it was looking for formulas like this=IF(E3F3,F3+1-E3,F3-E3) formula for total hours cellE3 is start timeF3 is finish timeG3 is your total hoursMy formula looked more like this - =IF($A1=',',(MOD(A2-A1,1)).24) if you started working 4:00 PM and ended 1:00 AM without using MOD, it will give you -15 but Mod will give you exactly hours of work which is 9 hours.It was still a bore to enter all the data, including dates for every day/time.