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: 
bindu
Contributor
Contributor

Re: Convert a integer number in seconds to dd:hh:mm:ss

Please help me,

How  to convert  one column integer number  into hh:mm:ss

 

4 Replies
Bill_Britt
Former Employee
Former Employee

Hi,

Try these to see if it will help.

=interval(interval#(4603422,'ss'),'d hh:mm:ss')

or

=interval(interval#(FIELDWITHSECONDS,'ss'),'d hh:mm:ss')

Bill - Principal Technical Support Engineer at Qlik
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.
SadlerS
Contributor III
Contributor III

Thanks for the information, I will try to figure it out for more. Keep sharing such informative post keep suggesting such post.

 

mybkexperience

smith11484
Contributor II
Contributor II

To do the conversion yourself follow these steps. Find the number of whole hours by dividing the number of seconds by 3,600. The number to the left of the decimal point is the number of whole hours. The number to the right of the decimal point is the number of partial hours.  Surge Card Info

Anonymous
Not applicable

The interval function will convert an integer simply by

interval(<integer value>, 'D hh:mm:ss')

---

I use this function in most of my reports like this...

At the beginning of the script I create a variable vExecStart by Let vExecStart = now();

At the end of the script I create a new variable vExecStop by Let vExecStop = now().

Then, I calculate the execution time with another variable by Let vExecTime = Interval(vExecStop - vExecStart, 'D hh:mm:ss').

Each of these, vExecStart and vExecStop are numbers like 44713.xxxxx.

HTH,

John

(aka johncaqc)