Announcements
cancel
Showing results for
Did you mean:
Contributor

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

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

4 Replies
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.
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

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)

Community Browser