> DROP TABLE IF EXISTS Attendances;
    CREATE TABLE Attendances (id int, employee_id int, timedata datetime, in_out varchar(55));
    INSERT INTO Attendances (id, employee_id, timedata, in_out)
    VALUES

id  employee_id           timedata        in_out
1        1          07.06.2017 19:25:10     OUT
2        1          08.06.2017 09:25:17     IN
3        1          08.06.2017 13:51:02     IN
4        1          08.06.2017 20:44:14     OUT
5        1          09.06.2017 01:10:04     OUT
6        1          09.06.2017 14:11:40     IN
7        1          09.06.2017 19:41:26     OUT
8        1          09.06.2017 11:35:00     IN
9        1          09.06.2017 20:36:06     OUT

employee_id      time_in                time_out
    1              NULL             07.06.2017 19:25:10
    1        08.06.2017 09:25:17           NULL
    1        08.06.2017 13:51:02    08.06.2017 20:44:14
    1              NULL             09.06.2017 01:10:04
    1        09.06.2017 14:11:40    09.06.2017 19:41:26
    1        09.06.2017 11:35:00    09.06.2017 20:36:06