Forum Discussion
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. J...
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/24if miles are in A1 and time is in B1