Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ..
i have this table :
Employee ID | Check In Time | Check Out Time |
1 | 9:30 | 12:00 |
2 | 15:00 | 21:05 |
3 | 8:30 | 9:00 |
5 | 7:30 | 23:02 |
6 | 5:35 | 8:30 |
i want to split the time in and time out .
so the user can see the employee who check in between (9:00 - 9:30) or between (9:30 - 10) ..... so on ..
how to do it ?
Not quite sure if I've understood your request properly, could you post your requested result, too?
Maybe this might help you:
You can use interval match to handle this.
I used every hour in my attached example.
Here is the script:
SET TimeFormat='h:mm';
Time:
LOAD
RowNo() as Row,
maketime(RowNo()-1) as Time
autogenerate 24;
EmpLog:
LOAD * INLINE [
Employee, CheckIn, Checkout
1, 9:30, 12:00
2, 15:00, 21:05
3, 8:30, 9:00
5, 7:30, 23:02
6, 5:35, 8:30
];
IntervalMatch(Time) Load CheckIn,Checkout Resident EmpLog;