Compare 7 colums of data in 17 worksheets

[Closed]
Report
Posts
2
Registration date
Sunday January 22, 2012
Status
Member
Last seen
January 23, 2012
-
Posts
2
Registration date
Sunday January 22, 2012
Status
Member
Last seen
January 23, 2012
-
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

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
802
It all depends upon how you have designed the main sheet. all weekly totals must be transferred to the main sheet
Posts
2
Registration date
Sunday January 22, 2012
Status
Member
Last seen
January 23, 2012

Just a simple addition of hours and minutes to show totals in the end column (j)