Difference Between Two Dates/Times

[meppwc]

I am trying to figure out a way of determining how many hours and minutes have transpired between two Date/Times
Cell C3 has the "Start Date/Time" and Cell D3 has the "End Date/Time"
I have both of these cells formatted to display the as follows:
9/16/2019 7:30:00 AM

In E3 (formatted as "Time" hh:mm), I have the formula =D3-C3
I am not getting the results that I am looking for

C3 = 9/16/2019 7:30:00 AM
D3 = 9/17/2019 8:30:00 AM
E3 = 1:00

E3 should equal 13:00 (13 hours and 0 minutes)

Any Suggestions as to what I am doing incorrectly?

 

[Joe4]

It is returning the right results, it just isn't formatted the way you want.
Apply the Custom Format of: [h]:mm

Note: In the actual example you presented, the actual answer is 25 hours, not 13 (it is more than one day).
It would only be 13 hours if the date in cell C3 was PM, not AM.

 

[meppwc]

Thanks for help Joe4

 

[Joe4]

You are welcome.