I am trying to create a work schedule that will graph all employees for an
entire week. I'm not sure how to set up the date portion of the spreadsheet
to get the graph.
In column A I place the employee names.
In Column B I have the start time for Monday.
In Column C I have the stop time for Monday.
...
...
...
In column O I have the start time for Sunday
In column P I have the stop time for Sunday.

My problem is there are a few employees that start at say 8PM on Monday and
end their shift at 7AM on Tuesday.

I have tried many different methods and all to no avail?

Any help would be greatly appreciated.

Thanks,

frustated El Bee!