Finding Shift Time Difference..

[Silambarasan1306]

Hi,

I have set of data's given below.

Emp	ShiftInTime	ShiftOuttime	PunchinTime	PunchOutTime
A	8:00	20:00	8:35	21:30
A	9:30	21:30	9:31	21:15
B	10:00	22:00	9:32	21:45
C	10:00	22:00	9:59	22:01
D	11:30	23:30	11:15	23:15
E	5:30	17:30	7:00	17:15

I want to calculate the person's who active who came >15 mts, who left >5mts, who came >30 mts based on their shiftintime & outtime for each employee.

Could anyone help me with this

[sunny_talwar]

You want this calculation in the script or front end?

[Silambarasan1306]

Anything is fine. But i need in front end.

Thanks

[sunny_talwar]

May be create flags?

Table:

LOAD Emp,

    ShiftInTime,

    ShiftOuttime,

    PunchinTime,

    PunchOutTime,

    If(PunchinTime - ShiftInTime > MakeTime(0, 15), 1, 0) as [15MinsLate],

    If(PunchinTime - ShiftInTime > MakeTime(0, 30), 1, 0) as [30MinsLate],

    If(PunchOutTime - ShiftOuttime > MakeTime(0, 5), 1, 0) as [5MinsLate]

FROM

[https://community.qlik.com/thread/231210]

(html, codepage is 1252, embedded labels, table is @1);

This may not be what you want, but I thought you can use this flags to do any calculations you might want to do.

[Silambarasan1306]

Hi Sunny,

If the person came 15mts late, then he won't be appear in 30mins late. See the above image,

Emp  Punchintime   shiftintime

A       8.35               8.00                          but he is coming in all the categories. Verify it.

Actually i want my output in frontend.

  like this,   15mts late, 15mts earlier,between 15mts earlier to 15 mts late

Thanks.