Check to see if a time is within a specified range

**MrsA** · 08-04-2011, 03:10 PM

Is there a way to check to see if a time is within a specified range by using a calculation. For example:

Time Scheduled Time Performed
3:00 3:07

So I want to created a formula where I can check that the time performed is within plus/minus 15 min of the time schduled. I have over 500 times to check and will continue to have more and the would make things a lot simpler if I could make Excel check the times. I know I can use (.25/24) to equal 15 minutes, but I don't know how to say plus or minus or if that's even possible. The +/- symbol does not work. It returns an error.

Thanks

**ConneXionLost** · 08-04-2011, 03:34 PM

Hi,

How about:

=IF(ABS(A2-B2)<=(0.25/24),"In Range","Out of Range")

Where A2 and B2 are your Time Scheduled & Time Performed.

Cheers,

**MrsA** · 08-04-2011, 03:45 PM

YES! IT works, oh thank you so much!!!!

**MrsA** · 08-04-2011, 03:46 PM

IS there a way to make the "out of range" be red text?

I also have onother time parameter where the actual time is in a window
Example:
Actual time 4:00
Window Earliest 12:00 Latest 8:00

Is there a function for this?