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

Question

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

abiola1 · Answer

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

sergeibaklan · Answer

johnae6ws&nbsp;
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

Forum Discussion

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

2 Replies

Resources