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

    Hours excluding weekends(Sat,Sun)48 Hrs

    Pavan R



      I am trying to get Network hours between two timestamps.

      This formula works in excel.




      also, the below works in qliksense



      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.