schedule worksheet

[Jim]

Is there a way to input times on sheet 1 and have it automatically fill-in
the appropriate time slots on sheet 2.

For example:
Jim works Monday from 5:30 am to 1:30 pm.
Tim works Monday from 1:00 pm to 9:30 pm.

If I had the format on sheet 2 set-up in half hour increments is there a
way to have it read what is input on sheet 1 and fill in the blanks on
sheet 2.

Jim 05:30 - 13:30
Tim 13:00 - 21:30

Thank you,

Jim

 

[Debra Dalgleish]

How are the times input on Sheet1? Is the information split into
columns, e.g.:

Name Day Start Finish
Jim Mon 5:30 AM 1:30 PM

Does Sheet 2 only show the Monday shifts, with other days on different
sheets?
What's the earliest start time for a shift, and the latest finish time?
Do any shifts start on one day and finish the next day?
How do you want the time slots filled in -- with a name, an "x", some
shading?

 

[Jim]

Debra,

Sorry it took me so long to get back to you.
Column a: names
Column b to h: days of week
name sun mon tues wed
James OFF 5:00a - 1:30p 5:00a - 1:30p 5:00a - 1:30p etc...

Each day is represented by it's own sheet.

Times go from midnight to midnight, and we run 24 hours a day and some
shifts will overlap from one day to the next.

I would prefer the slots to be filled in with the number 1 so that we can
count at the bottom of the sheet how many people are scheduled for a
particular hour.

Again, I apologize for not getting back any sooner, and I understand if you
can no longer help, but I would appreciate it if you can.

Thanks for your initial response, I do appreciate it.

Jim