K Tin
asked on
Conditional Format a Work Schedule
I am needing to conditional format a work schedule. I would like to color different times to indicate different shifts. Basically I want to tell excel "If the start time = 7:00 AND the end time = 17:00 THEN color both cells a certain color".
Is there an easy (amateur) way to do this?
TimeSheet.xlsx
Is there an easy (amateur) way to do this?
TimeSheet.xlsx
Please attach an example workbook
With your example only one of those time slots matches the 7:00 to 17:00 criteria.
What happens when the time slots don't match that specific time range?
Should it be start at/after 7:00 and finish at/before 17:00 = Day Shift?
Oscar S does 21:00 to 9:00 - presume this is a night shift.
At what point does a Night Shift start? eg Gabriel F does 15:00 to 0:00
What happens when the time slots don't match that specific time range?
Should it be start at/after 7:00 and finish at/before 17:00 = Day Shift?
Oscar S does 21:00 to 9:00 - presume this is a night shift.
At what point does a Night Shift start? eg Gabriel F does 15:00 to 0:00
ASKER
Right, so I am sure I can change up the formula once I have a baseline formula Rob.
As a rule of thumb though, I would say night shift is from 0:00 to 8:00, C shift is from 15:00 to 0:00, Day shift is from 8:00 to 16:00.
As a rule of thumb though, I would say night shift is from 0:00 to 8:00, C shift is from 15:00 to 0:00, Day shift is from 8:00 to 16:00.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Awesome you have helped greatly!! I am still having an issue with midnight however. any idea why the timeframe from 15:00 to 0:00 isn't working?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I saw the date was automatically inserted but I didn't even think about just deleting it.. duh! Thanks a bunch!
You're welcome! Glad I could help.