Journey time calculator

[Guest]

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

 

[Niek Otten]

In A3:

=A2/A1/24, format as Time

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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
|

 

[Guest]

I think this is far too complicated but it works. Note it is a helper cell
looking at the answer of 1.5 in A3. A3 must be formatted as a number to 2
decimal places

=INT(A3)&"HR "&INT(60*(A3-INT(A3)))&"Minutes"

 

[Guest]

Thanks to both Niek and Mike.

I wish I had a brain.

SGC