topic convert seconds in h:mm:ss in QlikView

convert seconds in h:mm:ss

Mon, 21 Feb 2011 09:39:22 GMT

i have a field having time in Seconds, i want to convert it to h:mm:ss,

Please suggest the best approach

Regards

convert seconds in h:mm:ss

deepakk — Mon, 21 Feb 2011 09:46:33 GMT

hi,

this might help you.

=time(Seconds/3600,'hh:mm')

convert seconds in h:mm:ss

Mon, 21 Feb 2011 09:51:51 GMT

hi Deepak,

take an example 7270 seconds, by ur formula ..

=time(7270/3600,'hh:mm:ss').

Its giving incorrect result.

take it as the exmple ,, it should give 2 hours 1 min and 10 seconds.

convert seconds in h:mm:ss

Anonymous — Mon, 21 Feb 2011 09:55:04 GMT

Try this one:

=time(Time#(7270,'s'))

convert seconds in h:mm:ss

Mon, 21 Feb 2011 09:56:06 GMT

Hi Surender,

You have to use time() function along with hh:mm:ss format in your script.

suppose your fieldname is timeinseconds then

time(timeinseconds,'hh:mm:ss') as timeinhour

Regards,

Yogesh

convert seconds in h:mm:ss

Mon, 21 Feb 2011 10:00:20 GMT

Thanks a lot Johnnes

convert seconds in h:mm:ss

tresB — Mon, 21 Feb 2011 10:01:46 GMT

Hi Sir,

what deepak said is right with a little mistake. it would be

Time(7270/(3600*24),'hh:mm:ss')

Regards, tresesco

convert seconds in h:mm:ss

Mon, 21 Feb 2011 10:57:09 GMT

thnx .. dear Tresesco..

convert seconds in h:mm:ss

Anonymous — Tue, 11 Oct 2011 21:15:27 GMT

I had to do a similar thing. I had time in seconds and needed to convert to HH:MM:SS. Tresesco's function works and should be marked as a solution to this problem. This question is currently marked as "not answered".

On the load script, I had a field called "timeinseconds". I created a new field called "hmstime". I can then do time math on this field.

num(div(timeinseconds,3600),00) & ':' & num((div(timeinseconds,60)-(div(timeinseconds,3600)*60)),00) & ':' & num(mod(timeinseconds,60),00) as hmstime

On my form I put a list box with an expression as the only field to calculate the length of the selected items.

='Duration: ' & time(sum(hmstime),'hh:mm:ss')

Tresesco's function Time(timeinseconds/3600*24),'hh:mm:ss') worked great and was simpler than my math.

Re: convert seconds in h:mm:ss

natebrunner — Thu, 13 Aug 2015 19:02:00 GMT

Thanks..worked great.

Re: convert seconds in h:mm:ss

sasiparupudi1 — Thu, 13 Aug 2015 19:13:07 GMT

=interval(Interval#(7270 ,'s'),'hh:mm:ss')

Re: convert seconds in h:mm:ss

MarcoWedel — Thu, 13 Aug 2015 21:29:48 GMT

i‌f your seconds might equal more than 1 day, you should use interval instead of time:

Interval(SecondsField/86400,'h:mm:ss')

regards

Marco

Re: convert seconds in h:mm:ss

wonkymeister — Tue, 03 Jul 2018 10:45:20 GMT

my expression

Sum(mySeconds) / (60*60*24)

then in the Number tab, format as time.

Jobs a good'n