This article was previously published under Q214133
This article describes the formula to calculate elapsed time in hours, minutes, and seconds when you are given the velocity and time.
To calculate elapsed time use the equation:
Time = distance divided by velocity.
Velocity is normally given in terms of distance divided by time, as inmiles per hour or feet per second. The one obvious exception to this is knots which are nautical miles per hour. To calculate time, the units must be consistent. For example, if the speed is given in terms of miles per hour (MPH) then the distance must be given in miles.
Excel calculates time as fractional parts of a day, so if the velocity contains an hours unit, you divide the distance by the speed, and then divide the result by 24 (the number of hours in a day). If the velocity contains a seconds unit, you divide the distance by the speed, and then divide the result by 86,400 (the number of seconds in a day).
After the fractional part of a day is calculated, you can format cells to change the data to read as hours, minutes, and seconds.
You can use the steps in the following examples to calculate elapsed time.