Shift gap is not getting flagged

[vasanrajeswaran]

Dear Good Sirs/Madams,

I have created a rota for my store, which is open from 5:30 AM to 11:15 PM. According to our business policy, at least one staff member must be present at all times, but there can be multiple shifts at any given time, with overlapping shifts. Under each day's column, it indicates if there is a gap in the AM or PM, or both. However, I am facing an issue where it is not flagging any gap in the middle. For example, if you look at Sunday, there is a gap between 4 PM to 4:15 PM, but the formula is not picking that up. Could you please help me resolve this issue?

Link to the spreadsheet


Thank you.

 

[RoryA]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

Shift gap is not getting flagged

Dear Sirs/Madams, I have created a rota for my store, which is open from 5:30 AM to 11:15 PM. According to our business policy, at least one staff member must be present at all times, but there can be multiple shifts at any given time, with overlapping shifts. Under each day's column, it...

www.excelforum.com

There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.