Forum Discussion
Excel formula for calculating average speed from date/time and distance
Hello all, I am trying to figure out a way to calculate average speed from distance and time. However, everything that I am finding thus far relates to time that would be in one day. I need mine ...
deca2499 I'm going to start by just referring you to this other website where you'll find a lot of information on dates and times and how Excel manages them. The quick answer to your question is that you should be able to enter into one cell the starting date and time, another the ending date and time, and do simple math to calculate the elapsed hours.
Enjoy your bike ride. Cross country rides are great fun!