Forum Discussion
Riley2435
Oct 16, 2024Copper Contributor
cond. format time if spec. value is pm, entered value AM next day
Hello, I'm trying to get a spreadsheet to conditional format if an actual time is past the scheduled time. I have my formulas built in where the condition is reading when I input values. My issue i...
HansVogelaar
Oct 16, 2024MVP
Assuming that the delay will never be more than 12 hours:
=E2+(D2-E2>12/24)<=D2
and
=E2+(D2-E2>12/24)>D2
and similar for columns F and G.