Conditional Formatting - Times

K

kristy_6278

tHow can I work out using conditional formating that this employee is double
booked with the time scheduled falling in between a current workshop he is
already scheduled at? I have one colume called Scheduling conflicts which I
want to have a formular that comes up red when an issue has occured.

Employee Name Date Scheduled Start Scheduled End
Bates, Jay October 6th 9:00:00 AM 5:00:00 PM
Bates, Jay October 6th 12:00:00 PM 1:30:00 PM
 
B

Bernard Liengme

Tell us how the data us set out
Hopefully, the name is in one column, the start time in another and the end
time in a third
If the times are stuffed into one column they will be text and very hard to
work with
best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count Employee Work Time - Don't Double-count Overlapping Apts. 0
Time Calculations and Conditional Formating 1
Calculate hours worked outside regular shift using date/time and iff condition 3
Conditional Formatting & Data Validation? 1
Conditional Formating on value of cell and prev cell 2
Conditional Formating for Time Sheet 3
Counting Cells which have Bold & Red Strike Effect Through Conditional Formatting 2
Conditional Formatting & UK Bank Holidays 5

Top