View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steve Crowther Steve Crowther is offline
external usenet poster
 
Posts: 2
Default Journey time calculator

I need to calculate journey time and display in hours and minutes.

A1 = 50 (for mph), A2 = 75 (for miles), A3 to display 1:30 (time in hours &
minutes) not 1.5 as it does in straight calculation.

Help please...

Many Thanks

SGC