Calculating difference in hours and minutes using two cells

[OfficeUser]

Hello, I have two cells using this format: m/d/yy h:mm AM/PM and I am trying to figure out the time difference between them to show for example 13h42m in a seperate cell. Any help is appreciated. Thanks!!

 

[DRSteele]

Try this:

Book1
	E	F	G
4		date and time	custom format
5	begin	10/17/21 5:55 AM	m/dd/yy h:mm AM/PM
6	end	10/17/21 2:51 PM	m/dd/yy h:mm AM/PM
7
8	difference (days)	0.371846296
9	difference (hors ,minutes)	22h:11m	h"h":mm"m"
Sheet1

Cell Formulas
Range	Formula
F6	F6	=NOW()
F8	F8	=F6-F5
F9	F9	=(F6-F5)*24

 

[Rick Rothstein]

Use this formula...

=F6-F5

and Custom Format that cell using this pattern (exactly as shown)...

[h]\hm\m

 

[OfficeUser]

Thank you both, makes sense now that I see it.