Formula speed in excel?

[SBAY3I]

HELLO ALL
HOW I CAN CHANGE SPEED VALUE FROM KILOMETRE IN HOUR TO MITRE IN MUNITE IN EXCEL.
ANY FORMULAS TO FIX IT

https://1drv.ms/u/s!As8Mdv-a95REhTVTGRT4Nc4oM2Uq

 

[jolivanes]

Do you want the Column that has the km/hr to have the m/min or in a new column?
Anyway, the conversion is 1 km/hr = 16.6666666667 (16 2/3) m/min

 

[SBAY3I]

i want to change value km/h to m/min in same column.
can you explain clearly your method

 

[MARK858]

First of all please don't post in all capitals as it is considered to be shouting.
Second if you are going to post a link make it to the actual excel file and not an image as most won't retype your data for testing, anyway...

Assuming that the column you want changed is column O try the macro below on a copy of your data (UNTESTED)...

Sub ConvSpeed()
    Dim LastRow As Long, X As Long
    LastRow = Range("O" & Rows.Count).End(xlUp).Row
    For X = 8 To LastRow
        Cells(X, "O").Value = Evaluate("O" & X & " * 1000 / 60")
    Next
End Sub

 

[jtakw]

Hi,

I think all OP wants is to replace his formula in Column O for Meter/Minute...

I was having a difficult time understand what he wanted in another thread of his...

Anyway, formula in O8, copied down.

Book1
	M	N	O
8	99.798	1:12:41	1373.052
Sheet137

Cell Formulas
Range	Formula
O8	=M8*1000/(HOUR(N8)+MINUTE(N8)/60+SECOND(N8)/3600)/60

NOTE: you'll probably need to change the Functions in the correct Language for your Excel.

 

[MARK858]

Hi,

I think all OP wants is to replace his formula in Column O for Meter/Minute...

You're probably right

 

[SBAY3I]

Hi,

I think all OP wants is to replace his formula in Column O for Meter/Minute...

I was having a difficult time understand what he wanted in another thread of his...

Anyway, formula in O8, copied down.

	M	N	O

<colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]8[/TD]
[TD="align: right"]99.798[/TD]
[TD="align: right"]1:12:41[/TD]
[TD="align: right"]1373.052[/TD]

</tbody>

Sheet137​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]O8[/TH]
[TD="align: left"]=M8*1000/(HOUR(N8)+MINUTE(N8)/60+SECOND(N8)/3600)/60[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]



NOTE: you'll probably need to change the Functions in the correct Language for your Excel.

thank you jtakw
your formula its work

 

[SBAY3I]

thank you MARK858
trying helping me but your code give higher value.

First of all please don't post in all capitals as it is considered to be shouting.
Second if you are going to post a link make it to the actual excel file and not an image as most won't retype your data for testing, anyway...

Assuming that the column you want changed is column O try the macro below on a copy of your data (UNTESTED)...

Sub ConvSpeed()
    Dim LastRow As Long, X As Long
    LastRow = Range("O" & Rows.Count).End(xlUp).Row
    For X = 8 To LastRow
        Cells(X, "O").Value = Evaluate("O" & X & " * 1000 / 60")
    Next
End Sub

 

[MARK858]

thank you MARK858
trying helping me but your code give higher value.

Give examples of numbers that are converting to incorrect values, what the result of the code is is and what you expect it to be.

 

[jtakw]

thank you jtakw
your formula its work

You're welcome, welcome to the forum.