Hi everyone,
I would like to setup some conditional format to highlight if a TIME entered is on the quarter hour (i.e. 12:15pm, 12:30pm, 12:45pm, 1:00pm, etc.).
I was thinking I could use MOD but time is really just a decimal, so how would you do something like this?