I have a spreadsheet that has two values; "Show Start" time (eg 20:30) and "Off Sale" time (eg: 20:25)

I'm using a large amount of data to check these values are set as they should be.

I'm looking to set a conditional format, to show if the "Off Sale" time is anything but exactly 5 minutes before the "Show Start" time, to check that shows are set to come off sale 5 minutes before the show starts.

EG:

Link to an example spreadsheet

CodePudding user response：

Use this in conditional formatting format rules

=ROUND(A3-B3*1,10)=ROUND((1/24/60)*5,10)