topic Network Days - Help with working hours. in QlikView

Network Days - Help with working hours.

Sat, 16 May 2009 17:06:05 GMT

Hi,

I would like to find the difference between two dates in net working hours. I can get the no. of days with networkdays, but cannot find the net working hrs. This I can easliy achive in excel but not in Qlikview.

I am attaching the sample Qlikview file and Excel file.

Thanks in Advance

- Rajesh Sanghvi

Network Days - Help with working hours.

disqr_rm — Sun, 17 May 2009 04:26:31 GMT

Hi Rajesh, check this out. Let us know if this is not what could help you.

http://community.qlik.com/forums/p/16513/64450.aspx#64450

Network Days - Help with working hours.

Mon, 18 May 2009 15:08:22 GMT

I do not have much data at the moment, but a year down the line there will be tens and thousands of records so How will be the performance then?

Re: Network Days - Help with working hours.

gruppo_cws_qvc — Thu, 09 Oct 2014 15:34:02 GMT

Dear Rajesh,

Use Networkingdays() for the days and

hour(start)-hour(end)/24 + minute(start)-minute(end) /1440 + seconds(start)-seconds(end)*86400

the results is the net days in decimal like this: 10,46 working days

have fun

Mark