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

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

bindu — Fri, 18 Feb 2022 06:24:01 GMT

Please help me,

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

Bill_Britt — Mon, 23 May 2022 19:49:40 GMT

Hi,

Try these to see if it will help.

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

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

Anonymous — Wed, 01 Jun 2022 20:18:57 GMT

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)