G
Guest
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!
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!