Difference in hours from two date/time fields?

[Infiltrator64]

How Can i show the difference in hours and minutes between two date/time fileds? Difference in hours/minutes from column f - column e.

Both fields are using a mm/dd/yy hh:mmAM/PM format.

 

[yee388]

=F1-E1 and format as [h]:mm

 

[Infiltrator64]

Thanks Yee.

That was too simple

I now have an issue where i need to =IF(F1<E1, F1-D1,F1-E1).

the F1-E1 works to show the difference in hours between the two but if F1 date is earlier than E1 date i need to use D1 date to subtract from F1 date instead. The formula I used above didn't work.