topic help with time calculation in QlikView https://community.qlik.com/t5/QlikView/help-with-time-calculation/m-p/389483#M145329 <HTML><HEAD></HEAD><BODY><P>HI, </P><P></P><P>i have a formula to work out the difference between 2 dates excluding weekends and out of office hours.</P><P></P><P>However, some start dates are at weekends and the calculation returns a minus date.</P><P></P><P>can anyone suggest a work around for these dates. so maybe if it starts sunday at 9pm it will only calculation the start time at monday 9am when office opens?</P><P></P><P>thanks</P><P></P><P>laura</P></BODY></HTML> Wed, 31 Oct 2012 15:57:30 GMT 2012-10-31T15:57:30Z help with time calculation https://community.qlik.com/t5/QlikView/help-with-time-calculation/m-p/389483#M145329 <HTML><HEAD></HEAD><BODY><P>HI, </P><P></P><P>i have a formula to work out the difference between 2 dates excluding weekends and out of office hours.</P><P></P><P>However, some start dates are at weekends and the calculation returns a minus date.</P><P></P><P>can anyone suggest a work around for these dates. so maybe if it starts sunday at 9pm it will only calculation the start time at monday 9am when office opens?</P><P></P><P>thanks</P><P></P><P>laura</P></BODY></HTML> Wed, 31 Oct 2012 15:57:30 GMT https://community.qlik.com/t5/QlikView/help-with-time-calculation/m-p/389483#M145329 2012-10-31T15:57:30Z