Expression: Convert seconds to HH:MM:SS

[#1]

Hello!

I have a problem, i import a table from SQL via ODBC, where there is a count in Seconds.

If i choose a date, i can make a statistics box to see the avg. but i seconds.

I want to see these numbers in HH:MM:SS.

Lets say i want to make a diagram showing the different times, how can i write an expression that convert to HH:MM:SS?

Thanks!

[#2]

hi

try this

Time(Time#(fieldname,'ss'),'hh:mm:ss')

[#3]

hi try like this

=Time(Time#('4550','ss'),'hh:mm:ss')

then output like this

01:15:50

[er_mohit]

use interval function

[#5]

I get "No Data to display"

[#6]

Please tell me how

[amit_saini]

Hi Erik,

Go to chart properties-->go to number tab  and select desired format you want.

Thanks,

AS

[#8]

No sorry that does not help.

I have a list with seconds.

And i want to express them like HH:MM:SS

[amit_saini]

Hi Erik,

This can be possible while selecting timestamp option the the properties you define your format hh:mm:ss

and you will get the correct result.

Thanks,

AS

[amit_saini]

Hi Erik,

You can also you this script:

dual( Date(TS,'YYYY-MM-DD') &'T' & time(TS,'hh:mm:ss'), num(TS) ) as Timestamp,

Thanks,

AS