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!

hi bjsmithinc, welcome to the forum. try this in D5:
=A5+(B5/100&" "&C5)+0

format accordingly to what you require. copy it to H5. then I5 is a simple:
=H7-D7
if you need to just see hours, custom format as:
[h]
with minutes:
[h]:mm

thanks for pointing that out, martin.

try this alternative too, modified using martin's formula:
=IF(C5="PM",A5+TEXT(B5,"00\:00")+0.5,A5+TEXT(B5,"00\:00"))

Thanks to you both. Working perfectly!!

maybe:
=A5+(TEXT(B5,"00\:00")&" "&C5)

please mark this as "solved" if it's ok.