Time Problem

[Ian Gilmore]

I am trying to solve a problem with rest periods within a week. I have a
schedule which covers two weeks and I need to find a method of determining
if there is sufficient weekly rest. Over two weeks in addition to a daily
rest requirement of 11 hours I need to be sure that at some point within the
two weeks a single block of 48hrs of rest is taken. I have been able to work
out the daily rest and rest that starts in the first week and finishes in
the second week. e.g over a weekend. The problem is when the break is taken
for example on Tue and Wed of week 1. the code gets it wrong because it
still looks for the finish of last attendance in week 1 and the start in
week 2.

Any help or suggestions would be most welcome.

Cheers

 

[Guest]

Ian: really hard to know how to help unless you give us more to go on. What
does your spreadsheet look like? And if you could post at least the relevant
section of your code we could see what you are trying to do and perhaps give
some ideas.