Time conversion and formatting. 2

[fender78]

I am trying to convert time which is in seconds to a hh:mm:ss format. I work on a davox dialer team and the time is exported in seconds through their reporting applications. I've made several attempts and am still unsuccessful.
I tried using a string quote, but not real good at those.
Thanks in advance. Jim

 

[synapsevampire]

numberVar dur;
numberVar hrs;
numberVar min;
numberVar sec;
stringVar hhmmss;

dur := {MyTable.MyDuration};

hrs := Truncate(Truncate(dur/60)/60);
min := Remainder(Truncate(dur/60),60);
sec := Remainder(dur,60);

hhmmss := totext(hrs, "0&quot + ":" + totext(min, "00&quot + ":" + totext(sec, "00"

hhmmss

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[fender78]

Thank you very much, I pasted your formula right in and it was amazing. Thanks again, Jim
A well deserved Star.

 

[fender78]

How would I go about summing the fields since their text objects now. Thanks, Jim

 

[synapsevampire]

Try:

dur := sum({MyTable.MyDuration})

Look at the help for SUM for options there.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com