I have a time in a cell that might be one of a few times, like 10:30 or 18:30 or 02:30. I need to write an if statement that returns true if the current time on the computer is within 2 hours of the time in the cell (so for 18:30, it returns true if its 16:30 to 18:29), otherwise just returns false. I'm getting confused with the logic cause i know i should be subtracting 2 hrs from the time in the cell, but having trouble with math operations on time values...

the cell will always be in the format 00:00 (military time?), any ideas how to do this?

Wyatt...