Hi, I need to create a gantt chart that will fill in the hours that an employee is scheduled to work. The work schedules sometimes cross over midnight. I have been able to get it to work correctly when their schedule doesn't go past midnight. All times are in military time with no decimals. I've attached what I have so far.
Last edited by k79miller; 07-22-2019 at 03:59 PM.
Assuming that you are talking about schedules like Richard's on Sunday 28-Jul try using the following as a conditional formatting rule for S14:AO14Formula:
Please Login or Register to view this content.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks