4 Replies Latest reply: Sep 21, 2018 7:51 AM by David Štorek RSS

    Hours excluding weekends(Sat,Sun)48 Hrs

    Pavan R

      Hi,

       

      I am trying to get Network hours between two timestamps.

      This formula works in excel.

      NETWORKDAYS(min({<Flag_First_Flow={'Yes'}>}Time_stamp_His),min({<Flag_Invoice_Approved={'Yes'}>}Time_stamp_His))-1-

      MOD(min({<Flag_First_Flow={'Yes'}>}Time_stamp_His),1)+MOD(min({<Flag_Invoice_Approved={'Yes'}>}Time_stamp_His),1)

       

      also, the below works in qliksense

      =NETWORKDAYS(min(INVOICE_DATE),min(SCAN_DATE))-1-MOD(min(INVOICE_DATE),1)+MOD(min(SCAN_DATE),1)

       

      But, when i use "Time_stamp_His" only it wont work.

      MOD(min(Time_stamp_His),1) will not give any result, just blank. I have checked the format both INVOICE_DATE,SCAN_DATE and Time_stamp_His format is same.


      Kindly help.