LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Time problem Jon New Users to Excel 1 June 3rd 09 08:38 AM
Time Problem Thurlow Excel Worksheet Functions 6 September 4th 07 05:04 PM
Time problem - Help please sawagashi Excel Discussion (Misc queries) 7 November 18th 05 10:15 PM
Time Problem B. Baumgartner Excel Discussion (Misc queries) 2 June 30th 05 09:05 PM
Problem when multipple users access shared xl-file at the same time, macrocode for solve this problem? OCI Excel Programming 0 May 16th 04 10:40 PM


All times are GMT +1. The time now is 06:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"