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

[SadlerS]

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

mybkexperience

[smith11484]

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]

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)