from seconds back to HH:MM:SS format

[lmonincx]

Hi,

I have a field loaded from the source containing the seconds a call has been open, I would like to display this not in seconds but in the format hh:mm:ss, is there such a syntax available?

Many thanks!

Linda Monincx

[#2 · Accepted solution]

Hi Linda,

see the short example.

Good luck.

Rainer

[#3]

Hi Linda,

Try the following Syntax :

Time#(Your_Seconds_Field,'ss')

[lmonincx]

Thanks that works

Linda

[lmonincx]

Thanks that works

Linda

[#6]

Anyone knows which solution is the most efficient between the two proposed ?

[lmonincx]

HI,

The formula: Time#(Your_Seconds_Field,'ss') is giving back the seconds only, like when i have 9000 seconds this gives back 9000.

The other formula: Time(Sec/86400, 'hh:mm:ss') gives back on the 9000 seconds: 02:30:00 , this was the value I was looking for.

Regards,

Linda

[#8]

My fault :

If you put the Field corresponding to

Time#(Your_Seconds_Field,'ss')

in a Table Box for example, you need to change the override the default format to Time.

If you use instead

Time(Time#(Your_Seconds_Field,'ss'))

, the format of your field will be in hh:mm:ss by default...

Just that i am not very ethusiastic about dividing a field by 86400 to have a good format...

[rwunderlich]

If your call may be open for more than a day, you can use Interval() instead of Time().

Interval(Seconds/86400, 'D hh:mm:ss')

-Rob