how to set date and check time

[#1]

Hi All,

i have a problem

i have a table in the dashboard like that

User ID	Check Time	Date
120	9/14/2014  11:42:30 PM	9/14/2014
120	9/15/2014  8:14:23 AM	9/15/2014
120	9/15/2014  11:47:19 PM	9/15/2014
120	9/16/2014  8:15:44 AM	9/16/2014
120	9/16/2014  11:43:54 PM	9/16/2014
120	9/17/2014  8:14:30 AM	9/17/2014

this table is for time attendance

the issue is the user must come at 12:00 pm and make check in and left at 8:00 am and thus make check out

what happened is the user may came earlier than 12:00 pm as shown in the table

he came on day 9/14/2014 at 11:42:30 and left on day 9/15/2014 at 8:14:23

so the first 2 records must be for the same Date not one for 9/14 and the other for 9/15

Also i want to create 2 fields one for Check In and the other for Check Out

i.e i want the output table to be one record for each day

User ID	Check In	Check Out	Date
120	11:42:30 PM	8:14:23 AM	9/15/2014
120	11:47:19 PM	8:15:44 AM	9/16/2014
120	11:43:54 PM	8:14:30 AM	9/17/2014

how to make this in the script or even in the chart??

[Gysbert_Wassenaar]

See attached qvw.

[#3]

ok,it works for the rows with this issue

but there are rows which are right and i want to keep them

i.e this row

User ID	Check Time	Date
120	8/11/2014  12:17:10 AM	8/11/2014
120	8/11/2014  3:14:29 PM	8/11/2014

These rows damaged

your solution solved a part and damaged another

any other help?