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.
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)
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)
Thank you so much,