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

[bindu]

Please help me,

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

[Bill_Britt]

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')

[Anonymous]

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)