Concatenate Date+Time+Am or PM then sum hours

Have six columns: "Date in" "Time In" "AM or PM" "Date Out" "Time Out" "AM or PM"

What I'm trying to get to from these columns is the amount of hours passed from time in to time out. It could be anywhere from a few hours to weeks.

I keep getting the dreaded #value error when I take the difference of my concatenated data(and I'm probably doing that wrong also).

Thanks all!