diazmlogistics
Board Regular
- Joined
- Nov 23, 2012
- Messages
- 56
I am trying to write an if statement to populate 1 of 3 return messages. "Early", "On-Time", or "Late". The Problem is the time passes over more than one day. If we arrive between the planned arrive and planned depart, we are "On-Time". Before the planned arrive, "Early" and after the planned depart "Late". Looking for help with one formula that will work for all three scenarios.
Current formula not working:
=IF(J64="","",(IF((L64+(M$1/60/24))>=J64,(IF((L64-(1.5/24))>J64,"Early","On-Time")),"Late")))
j64=Actual Arrival
M$1=0
L64= Planned depart
Thank You
<tbody>
</tbody>
Current formula not working:
=IF(J64="","",(IF((L64+(M$1/60/24))>=J64,(IF((L64-(1.5/24))>J64,"Early","On-Time")),"Late")))
j64=Actual Arrival
M$1=0
L64= Planned depart
Thank You
Actual Arrive Dynamic | Planned Arrive Static | Planned Depart Static | Statement |
23:00 | 23:45 | 01:15 | Early |
00:45 | 00:00 | 01:30 | On-Time |
02:15 | 00:30 | 02:00 | Late |
<tbody>
</tbody>