How to convert my response time field into seconds?

[sravankaripe]

i want to retrieve responsetime and convert it into seconds. please help me with Rex

IP                        Responsetime(ms)
12.34.567.890             163000
23.45.678.901             199000
34.56.789.012             162000

[somesoni2 · Accepted solution]

So the Reponsetime(ms) is already available, you just want to convert it to sec. If yes, then just add following eval to your search

your current search | eval "Responsetime(ms)"='Responsetime(ms)'/1000

[somesoni2]

This is single field or you've two fields IP and Responsetime(ms)?

[sravankaripe]

two fields