| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 | |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pop up calculator possible ? | Excel Discussion (Misc queries) | |||
| Integrated calculator in excel 07 instead of separate calculator | Excel Programming | |||
| how do i use the calculator at the same time i am using excell | Setting up and Configuration of Excel | |||
| How to audit and edit Excell files on the journey? | Excel Discussion (Misc queries) | |||
| calculator | Excel Discussion (Misc queries) | |||
Linear Mode
