Calculating the NetWorkDays between two timestamp fields with decimals

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have two timestamp fields which look like the following (and I have to admit I do not understand how to interpret the timestamp field. Would appreciate some help on that also)

Date1: 43007.908263889 (which is a timestamp for 29th Sep 2017)

Date 2: 43009.826921296 (which is a timestamp for 1st October 2017)

and I also have the total time in seconds between the 2 dates 1616940

I need to calculate the NetWorkDays to two decimal places.

eg.,

D1 = 5/01/2015 11:51:36 AM

D2 = 7/01/2015 10:28:13 AM

Networkdays = 3

The actual correct value I need is 1.94 days.

I followed another thread which suggested to use the following

NetWorkDays(d1, d2) -2 + (1-frac(d1)) + frac(d2)

But I can not get this to work and I am not sure if it is because I am using the timestamp rather than a date. When I enter the timestamp into a simple NetWorkDays function it returns the correct value as a whole number.

So I am wondering if I am going to be able to achieve what I need to using the NerWorkDays function or if I am better off trying to come up with an algorithm using the total time in seconds which is also available.

Any assistance would be greatly appreciated.

Re: Calculating the NetWorkDays between two timestamp fields with decimals

el_aprendiz111 — Sat, 10 Mar 2018 17:20:28 GMT

Hi,

1-option:

topic Calculating the NetWorkDays between two timestamp fields with decimals in QlikView

Calculating the NetWorkDays between two timestamp fields with decimals

Re: Calculating the NetWorkDays between two timestamp fields with decimals