Thread: Time Problem
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ian Gilmore[_2_] Ian Gilmore[_2_] is offline
external usenet poster
 
Posts: 3
Default Time Problem

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