Hi,

Can anyone help me with the following?

I have a workbook that will detail shift finish times and I'm hoping to create a formula or conditional format that can reference against a cell with the current time and update when the shift finish time is within -60mins/ -30mins and -15mins.

The current time cell is running from a macro that updates the current time every minute

Thank you