Hours Formula Between 2 Dates

Hi,

You have US format dates, which excel reads as text. One way to resolve is as follows..

1. Select column A
2. Data > Text to columns > Delimited
3. Select comma, space and forward slash as delimeters
4. Next, Finish

You should now have months in column A, days in column B, year in column C time in column D and AM/PM in column E

In F1, enter

=DATE(C1,A1,B1)+IF(E1="AM",D1,IF(E1="PM",D1+0.5,""))

Then copy for all your data, and format as you wish it to be displayed.


The difference in hours can then be calculated,

=(F1-F2)*24