subtract datetime in excel

Question

I'm trying to subtract two dates in two separate columns in excel, to find time difference. in h:mm format. The source format is the following.

11/18/2014 9:42:39 AM - 10/8/2014 12:17:13 PM

I have updated the columns to a date with the correct format.

When I subtract the two columns from eachother i get the following hh:mm value.

21:25

It seems to me that the calculation is not taking the dates into account.

What can i do to correct this?

Answer 1

The calculation works correctly, but "hh" does not convert days to hours. Format the result as [h]:mm instead.