Hours excluding weekends(Sat,Sun)48 Hrs

[rpavan17]

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.

[Gysbert_Wassenaar]

Make sure Time_stamp_His contains a real timestamp value and not just text values that only look like timestamps. If necessary use the TimeStamp# function to turn text values into timestamp values.

[rpavan17]

It gives the result for Timestamp for below formula.

NETWORKDAYS(min({<Flag_First_Flow={'Yes'}>}Time_stamp_His),min({<Flag_Invoice_Approved={'Yes'}>}Time_stamp_His)) . Network days result is correct

When i add MOD(min({<Flag_First_Flow={'Yes'}>}Time_stamp_His),1)+MOD(min({<Flag_Invoice_Approved={'Yes'}>}Time_stamp_His),1) It will not give any result.

For me, it looks like there is a issue with MOD and Time_stamp_His

[rpavan17]

The below works..

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

-1-frac(min({<Flag_First_Flow={'Yes'}>}Time_stamp_His))+frac(min({<Flag_Invoice_Approved={'Yes'}>}Time_stamp_His))

[DavidŠtorek · Accepted solution]

Hi,

you are absolutely right with MOD function. The reason is that MOD() requires INTEGERS as imputs, which surely timestamp is not.