Hi,
I'm trying to write a formula which will advise yes or no on whether a cell falls between the time 9-5 (or 09:00 - 17:00).
Example Data
M2= 14:26
P2= Yes
I tried - =IF(M9>="09:00"<"17:00","Yes","No") but it didn't work... Could someone please help? Thanks!
Bookmarks