topic Re: Convert seconds in hours in QlikView https://community.qlik.com/t5/QlikView/Convert-seconds-in-hours/m-p/758804#M662621 <HTML><HEAD></HEAD><BODY><P>=Interval(Time(Time#(YourTimeField,'ss'),'hh:mm'))*24</P><P></P><P>or </P><P></P><P>Simply</P><P></P><P>=Interval(Time#(YourTimeField,'ss'))*24</P></BODY></HTML> Fri, 20 Feb 2015 08:26:26 GMT MK_QSL 2015-02-20T08:26:26Z Convert seconds in hours https://community.qlik.com/t5/QlikView/Convert-seconds-in-hours/m-p/758802#M662619 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>In my datasource I have a timefield in seconds. I would like to convert that to hours.</P><P>I know how to do it like: 1:30, but in this case I would like to see 1.5 hours. Any ideas?</P><P></P><P>Kind regards,</P><P>Henco</P></BODY></HTML> Fri, 20 Feb 2015 07:55:51 GMT https://community.qlik.com/t5/QlikView/Convert-seconds-in-hours/m-p/758802#M662619 Anonymous 2015-02-20T07:55:51Z Re: Convert seconds in hours https://community.qlik.com/t5/QlikView/Convert-seconds-in-hours/m-p/758803#M662620 <HTML><HEAD></HEAD><BODY><P>Try</P><P>= your_seconds_field / (60 * 60)</P><P></P><P>If this doesn't work, can you post an example of your data.</P></BODY></HTML> Fri, 20 Feb 2015 07:59:45 GMT https://community.qlik.com/t5/QlikView/Convert-seconds-in-hours/m-p/758803#M662620 Colin-Albert 2015-02-20T07:59:45Z Re: Convert seconds in hours https://community.qlik.com/t5/QlikView/Convert-seconds-in-hours/m-p/758804#M662621 <HTML><HEAD></HEAD><BODY><P>=Interval(Time(Time#(YourTimeField,'ss'),'hh:mm'))*24</P><P></P><P>or </P><P></P><P>Simply</P><P></P><P>=Interval(Time#(YourTimeField,'ss'))*24</P></BODY></HTML> Fri, 20 Feb 2015 08:26:26 GMT https://community.qlik.com/t5/QlikView/Convert-seconds-in-hours/m-p/758804#M662621 MK_QSL 2015-02-20T08:26:26Z