Forum Discussion
Formula for time and color coding
Hi - Is it possible to make this where it is red only of the clock in time on is more than 5 minutes before the Tiger first Account Time and last account time and Dial pad first account and last acco...
Thank you. I tried that but it didn't work. I wonder if it matters that I use the Microsoft 365 which saves online?
Let's say the data start in row 2.
Use this conditional formatting formula:
=$B2-$A2>TIME(0,5,0)