Network Days - Help with working hours.

[#1]

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

[disqr_rm]

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

[#3]

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?

[gruppo_cws_qvc]

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