Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Time format

Hello,

The format of the time in the files I load is not how I want it to be and I need to change it.

This is the format of the files:

VirtualStockingTime.PNG

- After I add "Time(Time#...." some rows is correct, but some are not. Ex. Orig time 74752 (07:47:52) --> 03:15:02

- I guess that when the time is not equal to "hhmmss" it becomes an issue.

- How can I add in the script that some rows in the file are in this format "hmmss" and should be presented as "hh:mm:ss"?

* And another question is regarding the field "Completed time". This is in another format where ex. 15.15 = 15:09  (60*0,15=9)

- I want it to be presented as the previous example "hh:mm:ss"

Capture2.PNG

Capture.PNG

Thanks in advance!

15 Replies
Anonymous
Not applicable
Author

The numbers in the column dissapears when I load the script.

Capture.2222PNG.PNG

sunny_talwar

How about this

=Interval(Interval#(Num#([Completed Time], '##,##', ',', '.')*60, 'mm'), 'hh:mm:ss')

Anonymous
Not applicable
Author

A little bit closer , but really weird that it didnt work for all rows?

Capture222244454546.PNG

sunny_talwar

See if this is better

=Interval(Interval#(Num#([Completed Time], '##,##', ',', '.')*3600, 'ss'), 'hh:mm:ss')

Anonymous
Not applicable
Author

Thank you so much it works asdadasdsadadd.PNG

sunny_talwar

Awesome, please close the thread by marking correct and helpful responses.

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny