topic Re: Networking Hours in QlikView

Networking Hours

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

Hi,

I am working on a report, where I would like to convert the Net Working Days of a time-stamp (dd-hh-mm) into hours. I was able to use the working days function, but when I multiple this value by 24(hours in a day), I am getting a whole number.

This issue with this is when then net working days, is less than one day e.g 5 hours and 45 minutes, I still get 24 hours when using net working days function.

I know that there are a few forum on net working days, using start time, and end time. but in this case there is no start and end time require for this report.

Solutions are welcomed.

Thanks!

Re: Networking Hours

settu_periasamy — Wed, 31 May 2017 19:59:05 GMT

Can you provide sample data with expected output?

Re: Networking Hours

aagyemang — Tue, 06 Jun 2017 18:31:13 GMT

Hello Settu,

Attached you will find an Excel sample of what I am trying to achieve.

The "Working Days 24/7" field tells me the difference between two dates in days. Than I multiplied it by 24 to get the "Working Hours" in hours and minutes. I was able to do this function in Qlik by using the interval function.

I was able to figure out the networking days function in Qlik. The issue I have having is converting the net working days into hours. As displayed in the sample I provided the "Net Working Days" function in Excel displays the data without rounding the number to the nearest whole number, but in Qlik I can only get whole numbers.

In my example, the "Net Working Days" was 2.11, when multiplied by 24 I get 50.7. Please note that I used the integer function in Excel to display hours in number format.

Thanks

Re: Networking Hours

settu_periasamy — Thu, 08 Jun 2017 10:01:04 GMT

Hi,

Check this

Networkdays Calculation - Exact Decimals Required

Re: Networking Hours

aagyemang — Thu, 08 Jun 2017 19:20:04 GMT

Thank You!

I read the thread from that discussions, and found a calculation that works.