topic Re: How to convert time format? in Getting Data In

How to convert time format?

ravicheepa — Tue, 29 Sep 2020 18:58:04 GMT

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.

Re: How to convert time format?

adonio — Tue, 10 Apr 2018 17:16:43 GMT

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

Re: How to convert time format?

ravicheepa — Wed, 11 Apr 2018 07:01:56 GMT

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 ?

Re: How to convert time format?

adonio — Wed, 11 Apr 2018 12:11:50 GMT

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

Re: How to convert time format?

ravicheepa — Thu, 12 Apr 2018 09:28:29 GMT

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 ?