May be create flags?
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]
(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.
Community_231210.qvw 157.0 K
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