topic time in man-day in QlikView https://community.qlik.com/t5/QlikView/time-in-man-day/m-p/742068#M264967 <HTML><HEAD></HEAD><BODY><P>Hello, i have the following problem.</P><P>I have a field with time values and i have to get the man-days out of it. For example:</P><P>08:00:00 should be 1</P><P>01:00:00 should be 0,125</P><P></P><P>can you help me how to get this?</P></BODY></HTML> Wed, 04 Mar 2015 13:51:15 GMT lukaspuschner 2015-03-04T13:51:15Z time in man-day https://community.qlik.com/t5/QlikView/time-in-man-day/m-p/742068#M264967 <HTML><HEAD></HEAD><BODY><P>Hello, i have the following problem.</P><P>I have a field with time values and i have to get the man-days out of it. For example:</P><P>08:00:00 should be 1</P><P>01:00:00 should be 0,125</P><P></P><P>can you help me how to get this?</P></BODY></HTML> Wed, 04 Mar 2015 13:51:15 GMT https://community.qlik.com/t5/QlikView/time-in-man-day/m-p/742068#M264967 lukaspuschner 2015-03-04T13:51:15Z Re: time in man-day https://community.qlik.com/t5/QlikView/time-in-man-day/m-p/742069#M264968 <HTML><HEAD></HEAD><BODY><P>If that only first two numbers will be taken into account:</P><P>=LEFT('01:00:00',2)/8</P></BODY></HTML> Wed, 04 Mar 2015 14:02:40 GMT https://community.qlik.com/t5/QlikView/time-in-man-day/m-p/742069#M264968 robert_mika 2015-03-04T14:02:40Z Re: time in man-day https://community.qlik.com/t5/QlikView/time-in-man-day/m-p/742070#M264969 <HTML><HEAD></HEAD><BODY><P>sorry, that wasn 't the problem, but the question wasn t exact enough.</P><P>I solved it by my self. Thank you</P></BODY></HTML> Wed, 04 Mar 2015 14:08:30 GMT https://community.qlik.com/t5/QlikView/time-in-man-day/m-p/742070#M264969 lukaspuschner 2015-03-04T14:08:30Z