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 |
Journey time calculator
In A3:
=A2/A1/24, format as Time -- Kind regards, Niek Otten Microsoft MVP - Excel "Steve Crowther" wrote in message ... | 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 | |
Journey time calculator
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" "Steve Crowther" wrote: 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 |
Journey time calculator
Thanks to both Niek and Mike.
I wish I had a brain. SGC "Mike" wrote: 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" "Steve Crowther" wrote: 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 |
All times are GMT +1. The time now is 07:25 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com