Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Linda,
see the short example.
Good luck.
Rainer
Hi Linda,
Try the following Syntax :
Time#(Your_Seconds_Field,'ss')
Thanks that works
Linda
Thanks that works
Linda
Anyone knows which solution is the most efficient between the two proposed ?
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
My fault :
If you put the Field corresponding to
in a Table Box for example, you need to change the override the default format to Time.Time#(Your_Seconds_Field,'ss')
If you use instead
, the format of your field will be in hh:mm:ss by default...Time(Time#(Your_Seconds_Field,'ss'))
Just that i am not very ethusiastic about dividing a field by 86400 to have a good format...
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