Howdy. I'm trying to find a way to look at overlaps between "Overtime" scheduled and have it flag if there's "Coaching" time during one of the Overtime times listed. I've pulling these segments from a report.
Any help is appreciated.
Howdy. I'm trying to find a way to look at overlaps between "Overtime" scheduled and have it flag if there's "Coaching" time during one of the Overtime times listed. I've pulling these segments from a report.
Any help is appreciated.
Last edited by mike182; 06-28-2018 at 06:32 PM.
mike182,
Please check the forum rules.
You'll need to change your thread title to something more descriptive before Mod/Admin comes along an locks contributors out until you do.
In the meantime I'll have a look.
Dave
Thanks for changing the title.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Assuming that cell I12 should display 'Yes'
1) Change the values in Columns K:L of the Overtime sheet to numeric values (I used the paste special > multiply method)
2) Apply custom formatting: m/d/yyyy h:mm
3) Change the values in columns K:L of the Coaching sheet to numeric values
4) Apply the custom formatting again
5) Apply the same custom formatting to columns E:H on the Requires Attention sheet
6) Modify the formula in I2 and down to read: =IF(AND(E2<=H2,F2>=G2),"Yes","No")
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)
Bookmarks