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

Occasional Visitor

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

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

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

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

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

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