Hello everyone, here is my problem
So i have in cell A written the time 07:00 , under it in A2 i have written a time 07:30, in cell B1 i have written 5 (which represents an offset of 5 minutes, to do so i've red i have to add the time divided by 1440 or number/60/24), how will i be able to create a rule that from 07:30 to 07:35 the cell to become green and stay that way for whole 5 minutes? when it's 07:36 i have some other rule already prepared to make the cell all red.
Thanks in Advance
B.
Bookmarks