View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Patrick C. Simonds Patrick C. Simonds is offline
external usenet poster
 
Posts: 343
Default Using time in a formula

I need to calculate Miles Per Hour. I hav a worksheet where a start and end
time is entered. Then I subtract End time from Start time to get the elapsed
time:

14:50 - 14:25 which returns 0:25 (or 25 minutes)

How can I now use the returned result to divide distance by time?