topic how to calculate Hours? in QlikView https://community.qlik.com/t5/QlikView/how-to-calculate-Hours/m-p/1012149#M343309 <HTML><HEAD></HEAD><BODY><P> calculate hours between two dates like start date and end date. I have a qvw file attaching here can help on this. and i want to show that result in gantt chart</P></BODY></HTML> Tue, 03 Nov 2015 06:02:25 GMT 2015-11-03T06:02:25Z how to calculate Hours? https://community.qlik.com/t5/QlikView/how-to-calculate-Hours/m-p/1012149#M343309 <HTML><HEAD></HEAD><BODY><P> calculate hours between two dates like start date and end date. I have a qvw file attaching here can help on this. and i want to show that result in gantt chart</P></BODY></HTML> Tue, 03 Nov 2015 06:02:25 GMT https://community.qlik.com/t5/QlikView/how-to-calculate-Hours/m-p/1012149#M343309 2015-11-03T06:02:25Z Re: how to calculate Hours? https://community.qlik.com/t5/QlikView/how-to-calculate-Hours/m-p/1012150#M343310 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>([Start Time] - [Stop time]) * 24</P><P>or maybe better</P><P>round(([Start Time] - [Stop time]) * 24, 0.1)</P><P></P><P>Btw,</P><P>I noticed that one time field has Time with a capital letter and the other without. Consider being more consequent with your naming convention early in your development process as it will be hell to fix that later on.</P></BODY></HTML> Tue, 03 Nov 2015 09:55:12 GMT https://community.qlik.com/t5/QlikView/how-to-calculate-Hours/m-p/1012150#M343310 oknotsen 2015-11-03T09:55:12Z