Time Calculation (Spanning Dates and using Military Time)

Hello

I have 4 distinct columns.

Adm Date Adm Time Trans Date Trans Time
1/16/2014 937 1/16/2014 1045
1/1/2014 121 1/1/2014 121
1/14/2014 800 1/11/2014 735
1/30/2014 100 1/30/2014 205
1/13/2014 800 1/12/2014 1202

I would like to calculate the difference (# hours spanned from the dates shown). Unfortunately when we transfer the data the COLON is dropped from MILITARY TIME so I am having problems in the calculation. This is also made more difficult as some of the calculates span over two dates.

Any help would be appreciated.

Thank you. This works. Can you tell me how I would apply a formula in Row 2 if Column C had indicated 01/17/2014 instead of the same date.

Thank you.