Working Time Directive Spreadsheet?

Gary_zero

Does anyone know where I can download a spreadsheet preferably Excel, for calculating the WTD of 48 hours average over 17 weeks Thanks.

Gary_zero

I presume that one does not exist is it to complicated for Excel? any comments welcome

MissSarah1972

this? http://www.transportsfriend.org/wtd/records.html


I just googled 'Working Time Directive Spreadsheet'

Gary_zero

MissSarah1972 wrote: »

this? http://www.transportsfriend.org/wtd/records.html


I just googled 'Working Time Directive Spreadsheet'

Thanks I've had a look at this one but it's to simplistic it doesn't cater for holidays or other time off

MissSarah1972

write your own spreadsheet?

Notmyrealname

Gary_zero wrote: »

Thanks I've had a look at this one but it's to simplistic it doesn't cater for holidays or other time off

Holidays and sick are counted as a 48hr working week for the purposes of the WTD.

Gary_zero

Notmyrealname wrote: »

Holidays and sick are counted as a 48hr working week for the purposes of the WTD.

I wish it was that simple it's a government thing remember. Their website states if you have 4 days off holiday the reference period of 17 weeks is extended by 4 days and recalculated. Far to complicated for me to produce on Excel

Notmyrealname

Gary_zero wrote: »

I wish it was that simple it's a government thing remember. Their website states if you have 4 days off holiday the reference period of 17 weeks is extended by 4 days and recalculated. Far to complicated for me to produce on Excel

No, this is for haulage. It really IS that simple. For the purposes of the Road Transport Directive (the WTD for transport), a weeks holiday or sick is classed as a 48hr working week to prevent hauliers using holiday/sick to reduce the reference period average.

LittleVoice

Notmyrealname wrote: »

Holidays and sick are counted as a 48hr working week for the purposes of the WTD.

No. Holidays and sickness absence are excluded from the calculations for WTD 48-hour week average.