Sep 11 2020 03:50 PM
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
Sep 11 2020 03:56 PM
Sep 12 2020 03:24 AM
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