Calculate difference between two dates showing days, hours, minutes in military time

[jgangone]

I am trying to calculate the difference between two dates however none of my formulas seem to work.
I have Start time - Resolved Time = Duration

The day/time format is 2022-03-01 09:07:26
I am looking for a result that will say 0 Hours, 41 Minutes, 28 Seconds
The seconds aren't really needed though.
I think I am having issues since the times are in military time

 

[lrobbo314]

Book1
	A
1	2022-03-01 09:07:26
2	2022-03-01 09:48:54
3	0 hours 41 minutes 28 seconds
Sheet5

Cell Formulas
Range	Formula
A2	A2	=(A1+(1/24/60)*41)+(1/24/60/60)*28
A3	A3	=A2-A1

Where A3 has a custom format of...

h \hou\r\s mm \mi\nut\e\s ss \s\eco\n\d\s

 

[jgangone]

Thank you so much!!!!!!

 

[6StringJazzer]

Military time is just a display format. The way that Excel actually stores the date is the same for all formats.

Duration is Resolved Time - Start Time (you had it backwards)

You do the simple subtraction and format the result as desired.