topic help with script in QlikView https://community.qlik.com/t5/QlikView/help-with-script/m-p/449851#M1156202 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I am trying to put the following time calculation into the script but the script keeps failing and i am unsure why.</P><P>Can anyone help please?</P><P></P><P><SPAN style="font-size: 10.0pt; font-family: 'Tahoma','sans-serif'; color: black;">num(</SPAN><SPAN style="color: black; font-family: Tahoma, sans-serif; font-size: 10pt;">floor(</SPAN><SPAN style="color: black; font-family: Tahoma, sans-serif; font-size: 10pt;">sum(<SPAN style="color: #000000; font-family: Tahoma, sans-serif;">StartTime</SPAN>)/3600</SPAN><SPAN style="color: black; font-family: Tahoma, sans-serif; font-size: 10pt;">)</SPAN><SPAN style="color: black; font-family: Tahoma, sans-serif; font-size: 10pt;">,'00')</SPAN><SPAN style="color: black; font-family: Tahoma, sans-serif; font-size: 10pt;">&amp;':'&amp;</SPAN><SPAN style="color: black; font-family: Tahoma, sans-serif; font-size: 10pt;">num(</SPAN><SPAN style="color: black; font-family: Tahoma, sans-serif; font-size: 10pt;">60*right(num(sum(StartTime)/3600,'.00'),2)/100</SPAN><SPAN style="color: black; font-family: Tahoma, sans-serif; font-size: 10pt;">,'00') as <SPAN style="color: #000000; font-family: Tahoma, sans-serif;">StartTime</SPAN></SPAN></P><P></P><P><SPAN style="color: #000000; font-size: 10pt; font-family: Tahoma, sans-serif;">Thanks<BR /></SPAN></P></BODY></HTML> Tue, 19 Feb 2013 14:03:24 GMT 2013-02-19T14:03:24Z help with script https://community.qlik.com/t5/QlikView/help-with-script/m-p/449851#M1156202 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I am trying to put the following time calculation into the script but the script keeps failing and i am unsure why.</P><P>Can anyone help please?</P><P></P><P><SPAN style="font-size: 10.0pt; font-family: 'Tahoma','sans-serif'; color: black;">num(</SPAN><SPAN style="color: black; font-family: Tahoma, sans-serif; font-size: 10pt;">floor(</SPAN><SPAN style="color: black; font-family: Tahoma, sans-serif; font-size: 10pt;">sum(<SPAN style="color: #000000; font-family: Tahoma, sans-serif;">StartTime</SPAN>)/3600</SPAN><SPAN style="color: black; font-family: Tahoma, sans-serif; font-size: 10pt;">)</SPAN><SPAN style="color: black; font-family: Tahoma, sans-serif; font-size: 10pt;">,'00')</SPAN><SPAN style="color: black; font-family: Tahoma, sans-serif; font-size: 10pt;">&amp;':'&amp;</SPAN><SPAN style="color: black; font-family: Tahoma, sans-serif; font-size: 10pt;">num(</SPAN><SPAN style="color: black; font-family: Tahoma, sans-serif; font-size: 10pt;">60*right(num(sum(StartTime)/3600,'.00'),2)/100</SPAN><SPAN style="color: black; font-family: Tahoma, sans-serif; font-size: 10pt;">,'00') as <SPAN style="color: #000000; font-family: Tahoma, sans-serif;">StartTime</SPAN></SPAN></P><P></P><P><SPAN style="color: #000000; font-size: 10pt; font-family: Tahoma, sans-serif;">Thanks<BR /></SPAN></P></BODY></HTML> Tue, 19 Feb 2013 14:03:24 GMT https://community.qlik.com/t5/QlikView/help-with-script/m-p/449851#M1156202 2013-02-19T14:03:24Z