Formula Help - Differences between two time values

[Mr_Mad_Mike]

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Name
[/TD]
[TD]Start Time Old
[/TD]
[TD]Start Time New
[/TD]
[TD]Change Within 4 hrs?
[/TD]
[/TR]
[TR]
[TD]Jeff
[/TD]
[TD]9:30 AM
[/TD]
[TD]10:30 AM
[/TD]
[TD]Yes
[/TD]
[/TR]
[TR]
[TD]Walter
[/TD]
[TD]10:00 AM
[/TD]
[TD]9:30 AM
[/TD]
[TD]Yes
[/TD]
[/TR]
[TR]
[TD]Sam
[/TD]
[TD]1:00 PM
[/TD]
[TD]8:00 AM
[/TD]
[TD]NO
[/TD]
[/TR]
[TR]
[TD]Theodore
[/TD]
[TD]12:00 PM
[/TD]
[TD]7:00 AM
[/TD]
[TD]NO
[/TD]
[/TR]
[TR]
[TD]Brandt
[/TD]
[TD]2:00 PM
[/TD]
[TD]12:00 PM
[/TD]
[TD]YES
[/TD]
[/TR]
</tbody>[/TABLE]

Hello and thanks in advance for your help.

I'm trying to create a formula that will compare the time of two cells and determine whether or not the difference is more than 4 hours. I've tried a few approaches and I'm thinking it's something realatively simple but I'm just stuck. Can anyone point me in the right direction?

Thanks again,

 

[iggydarsa]

Put this formula in the cell below "Change Within 4 hrs?" and copy it all the way down:

=IF(ABS(C2-B2)>1/6, "No", "Yes")

 

[Mr_Mad_Mike]

Dang, I was so close.

Thank you sooooo much for your time.