time coversion

[infotork]

Can some one help me to convert  the time format ( hh:mm:ss:nnn) which in string  ( example 0:00:00.041) into seconds, the answer should be for this 0:00:00.041 is 0 seconds.

example : 1. 0:00:00.041 is 0 seconds 
                    2. 0:00:00.500 is 0.5 seconds.

[yeahnah · Accepted solution]

Hi @infotork 

Here's one possible example way to do it

| makeresults 
| eval duration=split("00:00:00.500", ".")
      ,micro_secs=(tonumber(mvindex(duration, 1))/1000)
      ,duration=mvindex(duration, 0)   
| convert dur2sec(duration) AS duration_secs
| eval seconds=round((duration_secs + micro_secs), 1)

[infotork]

Thank you so much,