topic Re: Time difference in QlikView

Time difference

Anonymous — Fri, 25 Sep 2015 06:29:34 GMT

TASK	Start -Time End-Time
A	8/31/2015 11:28:03 AM 8/31/2015 11:45:03 AM
B	8/28/2015 18:45:08 pM 9/2/2015 17:28:03 PM (29 and 30-sat sunday)
C	8/14/2015 09:10:07 pM 8/20/2015 13:28:03 PM (15 and 16-sat sunday and 17th -holiday)

office time between 9AM to 6PM

I want to findout the actual time taken by TASK A ,TASK B, TASK C

Re: Time difference

gautik92 — Fri, 25 Sep 2015 06:35:11 GMT

interval(Endtime-StartTime,'hh:mm:ss')

Re: Time difference

sasiparupudi1 — Fri, 25 Sep 2015 07:33:37 GMT

Use Networkdays..

may be check this thread

Re: Expression with Working Days and working Hours

hth

Sasi

Re: Time difference

SreeniJD — Fri, 25 Sep 2015 07:40:57 GMT

Hi Sumar,

As Sasi Suggested Use Networkdays as mentioned below..

=networkdays(start_time,end_time)*9 (as the difference between 9AM to 6PM is 9 hours here).

HTH

Sreeni

Re: Time difference

avinashelite — Fri, 25 Sep 2015 08:06:05 GMT

networkdays (start:date, end_date {, holiday})

Returns the number of working days (Monday-Friday) between and including start_date and end_date taking into account any optionally listed holidays. All parameters should be valid dates or timestamps.

Examples:

networkdays ('2007-02-19', '2007-03-01') returns 9

networkdays ('2006-12-18', '2006-12-31', '2006-12-25', '2006-12-26') returns 8

Re: Time difference

Anonymous — Fri, 25 Sep 2015 10:38:36 GMT

Hi,

Re: Calculate hours between two Date/Time strings

I have gone through this link. yes whatever presnt in this document will help me but i am not able to incorporate it.

Could you help me please.

I need time defferenc ebetween two days-

Please if possible need your help.

Re: Time difference

Anonymous — Fri, 25 Sep 2015 13:05:31 GMT

PLS help iu am not able to do it.

Re: Time difference

Fri, 25 Sep 2015 13:12:15 GMT

below is the definitiona and an example of network days - you should be able to replace the two differrent days in quotes with your field/variables for start time and end time

Definition:

networkdays

Returns the number of working days (Monday-Friday) between and including start_date and end_date taking into account any optionally listed holidays. All parameters should be valid dates or timestamps.

Examples

networkdays(‘2007-02-19’, ‘2007-03-01’) returns 9
networkdays(‘2006-12-18’, ‘2006-12-31’, ‘2006-12-25’, ‘2006-12-26’) returns 8

Re: Time difference

miguelbraga — Fri, 25 Sep 2015 15:24:03 GMT

Hi Suman,

I've analyzed your problema, and I manage to get the time interval between the Request Date and the Resolved Date which I think it's want you are after. Open the qwv that I make and analyze the straight table that I created. If this is not your solution please tell me

Miguel

Re: Time difference

Anonymous — Mon, 28 Sep 2015 07:24:58 GMT

Hi,

Thanks for your help.

I have requested to consider -

1. Sat, sunday and holiday

2. We usually works 8 hours, so we have to condirer all thos information while any calculation.

Please need help.

Regards

Re: Time difference

Anonymous — Mon, 28 Sep 2015 16:02:07 GMT

From the community I have copied and pasted the code. I am facing problem while i am trying to change inline(DT1,DT2) to actual script( Date raised, Date resolved). After that I want to do average by severity.

Please help.

Re: Time difference

miguelbraga — Mon, 28 Sep 2015 16:27:53 GMT

Hey again,

Please check up my solution with now the average that you want.

If the result isn't what you expected please let me know.

Miguel

Re: Time difference

Anonymous — Tue, 29 Sep 2015 10:11:54 GMT

Hi,

I think you not considered-

1. office time between 9AM to 6PM

2. sat sunday

3.Holiday