Calculating the percentage of a timestamp difference

[gemcgraw]

I'm attempting to calculate the difference of two time stamps in hh:mm:ss and it's giving me strange percentages that don't make sense.
Example: What's the percentage of 60:34:49 hours is out of 1689:40:25 total hours. If the frustration from the fact I need to compact these to hh:mm and drop the seconds?

 

[JamesCanale]

Note the formatting for this

MrExcelPlayground6.xlsx
	A	B
32	60:34
33	1689:40
34	3.6%	percent
35	1629:05	difference
Sheet18

Cell Formulas
Range	Formula
A34	A34	=A32/A33
A35	A35	=A33-A32

it should be [h]:mm for the times.

 

[gemcgraw]

Note the formatting for this

MrExcelPlayground6.xlsx
	A	B
32	60:34
33	1689:40
34	3.6%	percent
35	1629:05	difference
Sheet18

Cell Formulas
Range	Formula
A34	A34	=A32/A33
A35	A35	=A33-A32

it should be [h]:mm for the times.

Thanks James! I see those seconds were complicating things. I appreciate the help! BTW... those meatballs look amazing!

 

[JamesCanale]

Showing the seconds (or not) don't matter in this calculation. What might matter is what you do to get rid of the seconds...

I have the meatballs up there to remind myself and others that I am a meatballer on this site. But I enjoy it.