How do I convert HH:MM:SS to a numeric value

%3CLINGO-SUB%20id%3D%22lingo-sub-1659659%22%20slang%3D%22en-US%22%3EHow%20do%20I%20convert%20HH%3AMM%3ASS%20to%20a%20numeric%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1659659%22%20slang%3D%22en-US%22%3E%3CP%3ELooking%20for%20a%20way%20to%20use%20a%20formula%20function%20to%20change%20time%20to%20a%20number.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIE%3C%2FP%3E%3CP%3Ea%20time%20of%20action%20is%206%20hours%20and%2030%20minutes.%3C%2FP%3E%3CP%3EI%20would%20like%20to%20convert%20this%20to%206.5%20for%20the%20purpose%20of%20calculations.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJack%20drove%20320%20miles%20in%206hrs%20and%2030%20minutes.%3C%2FP%3E%3CP%3Ehis%20speed%20average%20is%20320%20%2F%206.5%3D%2049.2%20MPH%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20could%20also%20be%20used%20in%20geometry%20Degrees%2C%20minutes%20and%20seconds%20conversion%20to%20a%20numeric%20value%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1659659%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1659693%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20convert%20HH%3AMM%3ASS%20to%20a%20numeric%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1659693%22%20slang%3D%22en-US%22%3EHello%2C%3CBR%20%2F%3E%3CBR%20%2F%3EI%20believe%20the%20post%20in%20the%20link%20below%20answers%20you%20question.%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fwww.ablebits.com%2Foffice-addins-blog%2F2015%2F07%2F01%2Fexcel-convert-time-decimal%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.ablebits.com%2Foffice-addins-blog%2F2015%2F07%2F01%2Fexcel-convert-time-decimal%2F%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EKindly%20go%20through%20it..%3CBR%20%2F%3E%3CBR%20%2F%3ERegards%3C%2FLINGO-BODY%3E
Occasional Visitor

Looking for a way to use a formula function to change time to a number.

 

IE

a time of action is 6 hours and 30 minutes.

I would like to convert this to 6.5 for the purpose of calculations.

 

Jack drove 320 miles in 6hrs and 30 minutes.

his speed average is 320 / 6.5= 49.2 MPH

 

This could also be used in geometry Degrees, minutes and seconds conversion to a numeric value

2 Replies
Hello,

I believe the post in the link below answers you question.

https://www.ablebits.com/office-addins-blog/2015/07/01/excel-convert-time-decimal/

Kindly go through it..

Regards

@johnae6ws 

In Excel for datetime calculations one day is equal to 1, thus one hour will be 1/24, thus your formula could be

=320/( TIME(6,30,0)*24)
or
=320/TIME(6,30,0)/24

or

=A1/B1/24

if miles are in A1 and time is in B1