Compare 7 colums of data in 17 worksheets

Closed
noggsy Posts 2 Registration date Sunday January 22, 2012 Status Member Last seen January 23, 2012 - Jan 22, 2012 at 12:13 PM
noggsy Posts 2 Registration date Sunday January 22, 2012 Status Member Last seen January 23, 2012 - Jan 23, 2012 at 07:34 AM
Hello,

I am a complete beginner with Excel, so please excuse me if this makes no sense !!

I have made a spreadsheet for driving hours which adds up the hours driven and gives a weekly total so I can allocate driving duties based on the UK legal limits, and have made it cover the 17 weekly period we work to using 17 worksheets (week1, week 2 etc). However, I want to check that a driver has had 1 day off per week and at least 2 consecutive days over a two week period. What I am trying to achieve is.. ...if I try to allocate a driver a duty and he has not had these breaks it returns a text string ( in column K on my sheet ). I have spent a lot of time searching and a lot of trial and error, any help would be gratefully received and stop me shouting at my PC !!




Related:

1 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Jan 22, 2012 at 09:25 PM
It all depends upon how you have designed the main sheet. all weekly totals must be transferred to the main sheet
0
noggsy Posts 2 Registration date Sunday January 22, 2012 Status Member Last seen January 23, 2012
Jan 23, 2012 at 07:34 AM
Just a simple addition of hours and minutes to show totals in the end column (j)
0