Formula calculates correct time difference but not calculating >12 hrs means late

I have this formula that is calculating the time difference between two dates and time. Now just some clarification I have in cells of the two different dates and times that say NULL that is supposed to be. But i realized that my formula was calculating correctly except it wasn't bringing into account that if the difference between the two dates and times was greater than 12 hour that meant it was late.
Here is my formula that is used my sample excel
=IF(SIGN(D4-I4)<0,"LATE ","")&INT(ABS(D4-I4))&" days, "&HOUR(ABS(D4-I4))&" hours, "&MINUTE(ABS(D4-I4))&" minutes and "&SECOND(ABS(D4-I4))&" seconds"

I am also attaching a sample excel so you can see how the formula is calculating.

I believe that Tsjallie incorporated the IF statement, looks like a great solution!

@Tsjallie I know that the first two cells in column E have #VALUE! errors that is supposed to be that way. I need column E to determine based on columns D and I and calculated in E if it is late in Column J. When I implemented your formulas to columns D, I and E it removed the LATE before the days, etc in Column E but didnt change Column J.

I need help creating a formula that calculates time difference between two different dates and times. Sometimes the dates can be the same but the times can be different. In addition in a another column I need to calculate whether based on this formula the time difference is considered late or on time. This all based on the fact that any calculation of the time difference that is under 12 hrs is considered on time. I have a sample excel sheet that shows what I am trying to do with a formula for both but I dont believe that the formula for time difference is considering the less than 12 = on time rule.

PLEASE NEED ANY HELP BEEN STUCK ON THIS FOR A COUPLE WEEKS NOW!!!!!
Any help is super appreciated.

the solutions above were not working.

still using the same sample from above

here i will attach a more updated sample

here is the updated excel

sorry here is an updated one with an example with dates and times for both.

Just to clarify that the excel you sent me considers that even if the time difference is less than 12 hrs its considered on time?

it becomes late when the time difference is greater than 12 hours

it works the only thing i was wondering could we have the times include the seconds.

E2: I2-D2 (no need so complicated formulas)
Then, format the cell as: d "days" h "hours" m "minutes" s "seconds"

Im still having the issue with converting my dates to your formula Glenn Kennedy. I am attaching the file with the issue. it just the first row of the sheet because it was giving me a weird number.

yes thank you but now I noticed that the determination for it to be on time or late isnt work there is an extra column that basically makes a 0 on time and 1 late but its showing most are on time despite being over 12 hours for obviously some lines.

Originally Posted by Glenn Kennedy

Josephtey - valid point. I didn't even look at that cell!! have some Rep.

Thanks Glenn!

Thank You so much for all the help