Mr_Mad_Mike
New Member
- Joined
- Feb 26, 2014
- Messages
- 5
Name | Start Time Old | Start Time New | Change Within 4 hrs? |
Jeff | 9:30 AM | 10:30 AM | Yes |
Walter | 10:00 AM | 9:30 AM | Yes |
Sam | 1:00 PM | 8:00 AM | NO |
Theodore | 12:00 PM | 7:00 AM | NO |
Brandt | 2:00 PM | 12:00 PM | YES |
<tbody>
</tbody>
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,