If statement formula for Time over multiple days

[diazmlogistics]

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

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>

 

[oldbrewer]

Actual Arrive	Planned Arrive	Planned Depart	Statement
03/09/2016 23:00	03/09/2016 23:45	04/09/2016 01:15	early
04/09/2016 00:45	04/09/2016 00:00	04/09/2016 01:30	on time
04/09/2016 02:15	04/09/2016 00:30	04/09/2016 01:45	late
		formula in D2
		=IF(AND(A2>=B2,A2<=C2),"on time",IF(A2<B2,"early","late"))
	I have made the "times" into date_times
	these can be formatted as times only if necessary
	but must be entered as date_times

<colgroup><col><col><col><col><col span="3"></colgroup><tbody>
</tbody>

 

[diazmlogistics]

Thank you very much. I will see if I can work the date_times in.