what is the use case in converting
in any case, run this anywhere and apply:
| makeresults count=1 | eval times = "23:54, 12:35, 14:32, 8:12" | makemv delim="," times | mvexpand times | eval new_time = replace(times,":","")
hope it helps
Thanks Adonio, it helped. One more thing I am trying to do i.e. Displaying execution time using Single value chart but as there are : in time format it displays the time but not able to do formatting like color change as because of : there colour ranges do not work same with trend line.
Is there any way to display time in Single value graph as HH:MM:SS along with color and trends option ?
I want use Single value chart to display time in HH:MM:SS format and also want to change color on range of time for example time is in between 06:30:00 to 7:30:00 then red color etc.. and want to show past trends as well.
So is there any way I can make this happen ? I tried passing values in format HH:MM:SS but it seems like single value graph work proper with numeric values only. Because of : in value it is not behaving proper.
So just need to know if there any way ?