How to convert time format?

[ravicheepa]

I have time in Variable End_Time = 23:06 and want to convert this to 2306. How can I do that? I tried Strptime(End_Time, %z) but it is not working.

[adonio · Accepted solution]

hello there,

what is the use case in converting 23:06 to 2306?
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

[ravicheepa]

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 ?

[adonio]

can you please elaborate?
not sure i understand what is the anticipated result

[ravicheepa]

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 ?