Hi,

Am Fri, 27 Apr 2018 10:46:18 -0700 (PDT) schrieb GARYWC:

F16 contains 18:30:00 and is displayed as 6:30 PM
H16 contains 20:42:00 and is displayed as 8:42 PM

(Both cells a Format Cells: Number; Custom; Type: h:mm AM/PM)

What formula do I put in D16 so the difference between H16 and F16 is displayed as 2 hr 12 mins ?

try:
=INT((H16-F16)*24)& " hrs "&ROUND(MOD((H16-F16)*24,1)*60,0)&" mins"


Regards
Claus B.
--
Windows10
Office 2016