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

Copper Contributor

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