Excel - Comparing specific date and times

[HeyYoWL]

I'm trying to create a tracker that contains a column to check if we've met SLA.

Column A - Date Received
Column B - Time Received
Column C - Date and Time Combined (A2+B2)
Column D - Date Resolved
Column E - Time Resolved
Column F - Date and Time Resolved (D2+E2)

Essentially, what I need to check is:

If the date received (Column A) and time received (Column B) was after 12 PM, the date resolved (Column D) should be the next business day by 12 PM (Column E).

Ex: Received request at 2pm on Monday July 31st, resolved Tuesday August 1st at 11 AM -> SLA Met

Ex: Received request at 2pm on Monday July 31st, resolved Tuesday August 1st at 3 PM -> SLA Not Met

I can't figure out how to combine the date and time data to plug into my formula. I've tried combining the date and time as you can see above:

=IF(AND(O2="Team Inbox", C2 >= TIME(12,0,0)), NETWORKDAYS(A2,E2,Holidays[2023Holidays])<=2, G2 <= TIME(12,0,0)), "Yes", "No")

Column O = Specific Inbox [2023Holidays] = Table of holidays for business

Any help would be appreciated!

 

[HeyYoWL]

networkdays between two adjacent dates will result in a 2. the time in Column E turns into a fraction of a day. So noon is 0.5. adding that to the networkdays and you are looking for a number that is less than or equal to 2.5 - noon on the second day. So if something comes in at 1pm, and gets done by 5 on the same day, it'll come to 1+17/24 which is less than or equal to 2.5 too.

The =1 means that the networkdays are the same day.

Much appreciated!