Split Time

[zturaiki]

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 ?

[swuehl]

Not quite sure if I've understood your request properly, could you post your requested result, too?

Maybe this might help you:

http://community.qlik.com/thread/38841

[wms_manis]

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;