topic seconds to hour/minutes/seconds in QlikView https://community.qlik.com/t5/QlikView/seconds-to-hour-minutes-seconds/m-p/234480#M85898 <HTML><HEAD></HEAD><BODY><P>Time() is limited to a 24 hour clock, so I'm guessing we want interval(Seconds/86400,'hh:mm:ss') instead. Obviously the same basic idea, though. Divide by 86400, tell qlikview it is an interval of time, and format as desired.</P></BODY></HTML> Sat, 08 May 2010 00:50:57 GMT johnw 2010-05-08T00:50:57Z seconds to hour/minutes/seconds https://community.qlik.com/t5/QlikView/seconds-to-hour-minutes-seconds/m-p/234478#M85896 <HTML><HEAD></HEAD><BODY><P>I got workhours in seconds 3890478 sec.</P><P>Now this most be in 00:00:00</P><P>how can I do this ?</P><P>thx</P></BODY></HTML> Fri, 07 May 2010 08:53:20 GMT https://community.qlik.com/t5/QlikView/seconds-to-hour-minutes-seconds/m-p/234478#M85896 2010-05-07T08:53:20Z seconds to hour/minutes/seconds https://community.qlik.com/t5/QlikView/seconds-to-hour-minutes-seconds/m-p/234479#M85897 <HTML><HEAD></HEAD><BODY><P>Devide your seconds by 86400 and format with the time format codes.</P><P>time(&lt;your seconds&gt;/86400, 'hhh:mm:ss')</P></BODY></HTML> Fri, 07 May 2010 12:32:01 GMT https://community.qlik.com/t5/QlikView/seconds-to-hour-minutes-seconds/m-p/234479#M85897 2010-05-07T12:32:01Z seconds to hour/minutes/seconds https://community.qlik.com/t5/QlikView/seconds-to-hour-minutes-seconds/m-p/234480#M85898 <HTML><HEAD></HEAD><BODY><P>Time() is limited to a 24 hour clock, so I'm guessing we want interval(Seconds/86400,'hh:mm:ss') instead. Obviously the same basic idea, though. Divide by 86400, tell qlikview it is an interval of time, and format as desired.</P></BODY></HTML> Sat, 08 May 2010 00:50:57 GMT https://community.qlik.com/t5/QlikView/seconds-to-hour-minutes-seconds/m-p/234480#M85898 johnw 2010-05-08T00:50:57Z