View Single Post
  #19   Report Post  
Posted to microsoft.public.excel.misc
GARYWC GARYWC is offline
external usenet poster
 
Posts: 80
Default Difference between two times

My spreadsheet contains data related to my walking excursions.

For each day I walk, I record (for example):

Date Friday, April 27
Miles 7.57
Duration 2 hrs 27 mins
MPH 3.09
Start time 5:40 PM
Start temp 72
End time 8:07 PM
End temp 61
Route Monroe, La Sierra, McAllister Pkwy, Dufferin, Monroe, Tropicana

It also shows the number of walking days, the total number of miles and the straight-line distance from my home to various cities. For example:

In 149 walking days, I've walked 967.81 straight-line miles from Riverside CA to:

10 miles S of Seattle, Washington
64 miles SW of Rapid City, South Dakota
184 miles NW of San Antonio, Texas
132 miles NW of Kerrville, TX (in the path of April 2024 total solar eclipse)