Help to modify conditional formatting formulas that display on time and late based on time

Hello

I am using the following formulas to conditionally format my worksheet.

Red: (Late)

Formula:

Please Login or Register  to view this content.

Green: (On time)

Formula:

Please Login or Register  to view this content.

The problem I noticed is when the scheduled time/date to be completed is the next day. If a task is completed (see row 5 for example) on July 1st @ 23:40 and is not scheduled to depart until July 2nd @1:30am it formats it red (late) and I would like it to be green. Is there a way to modify the formula so this does not happen? Please see attached worksheet.

Thank you

Red: Please try

Formula:

Please Login or Register  to view this content.

Green: Please try

Formula:

Please Login or Register  to view this content.

I'm sorry, I switched the rules for green and red.

Correct is

Red: Please try

Formula:

Please Login or Register  to view this content.

Green: Please try

Formula:

Please Login or Register  to view this content.

Thanks for the feedback and rep .

Oh that's very messy for me.
Time for a strong cup of coffee.

The rep. I really didn't think it deserved. I was wrong twice. .

Red:
Please try

Formula:

Please Login or Register  to view this content.

Green:
Please try

Formula:

Please Login or Register  to view this content.

@Hans I forgot to mention on more problem I am having. I attached the file again to illustrate. It is regarding the formula in column D, displaying status of delivery "On time" or "Late". In cells D5:D7 it displays "Late" and it is not. Could you please show me how to use the new formula you helped me with to fix this problem.

Figured It out thx hans.