Thread: Compute duration and miles-per-hour and total miles
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Roger Govier[_11_] Roger Govier[_11_] is offline
external usenet poster
  
Posts: 18
Default Compute duration and miles-per-hour and total miles
On Monday, 16 April 2018 06:55:25 UTC+1, GARYWC wrote:
How can I compute the duration and mph in each row?

After I move the other cells down one row, I insert the new day's info in the first row. How can I compute the total miles (of all rows)?

The solution given will work.
You just need to format column B as Time 00:00:00
and format column C as Number

You could also use the formula in column B of =MOD(E2-D2,1)
Reply With QuoteReply With Quote