Hi,
My table look like this ,
| creation_date | event_name | person_num | full_name | | 7/21/2016 18:00:00:00 PM | CLOCK_IN | 40014 | OSU | | 7/21/2016 19:00:00:00 PM | CLOCK_OUT | 40014 | OSU | | 7/21/2016 20:00:00:00 PM | CLOCK_IN | 40014 | OSU | | 7/21/2016 21:00:00:00 PM | CLOCK_OUT | 40014 | OSU | | 7/21/2016 21:10:00:00 PM | CLOCK_IN | 40014 | OSU | | 7/21/2016 21:30:00:00 PM | CLOCK_OUT | 40014 | OSU | |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
How to display in gridview like this
| creation_Date | person_num | full_name | CLOCK_IN1 | CLOCK_OUT1 | CLOCK_IN2 | CLOCK_OUT2 | CLOCK_IN3 | CLOCK_OUT3 | HoursWorked |
| 7/21/2016 | 40014 | OSU | 18:00 | 19:00 | 20:00 | 21:00 | 21:10 | 21:30 | 2.2 |