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 !!




1 reply

venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
805
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