Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 17
Default find and display all possible start times and days to work

Hello,

I'm looking to find a macro that will:

Read start time ranges and days to work based on entries to an online form.
Let's say, for example:

Agent 1 wants to work an 8-hour scheudle (8.5 w/lunch) that starts between
8:00 AM and 10:00 AM and is willing to work any five contiguous days during a
Sun-Sat work week.

I would like the macro to identify every possilble shift outcome, days and
hours(start times on the half-hour, 8:00 AM, 8:30 AM, etc., days can be any 5
contiguous days)

Shift start time ranges, let's say, are 8:00 AM in cell A1 and 10:00 AM in
cell A2, so the shift can start at any time (including the times listed)
between those two times.

I would think that making adjustments for a 4-day (10hrs/day) per week shift
would be fairly simple at that point, but if I would need to do anything
special for that, please let me know.

Any help you can provide would be greatly appreciated.

Thank you for your time and attention.
Reply
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
Function to find/display the date X number of days later? a0xbjzz Excel Worksheet Functions 1 October 26th 07 02:12 PM
use Now() in two cells for start and finish times DaveM Excel Worksheet Functions 1 April 5th 06 12:22 AM
find days and hours between 2 sets of dates and times The Auditor Excel Discussion (Misc queries) 1 February 3rd 06 08:58 PM
How to chart start and stop times tresscott Charts and Charting in Excel 1 April 10th 05 11:04 PM
Countif("between start/end times) Ian Jones Excel Discussion (Misc queries) 0 January 6th 05 07:17 PM


All times are GMT +1. The time now is 09:54 PM.

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

About Us

"It's about Microsoft Excel"