Attendance Report Compilation

Hi,

I have a raw attendance log from time machine in this format:

3 2014-10-01 12:06:04 1 0 15 0
4 2014-10-01 16:01:30 1 1 15 0
2 2014-10-01 17:06:25 1 1 15 0
5 2014-10-01 17:06:29 1 1 15 0

I have been able to format the data as under:

Date Time Employee Name In Time Out Time
2014-10-01 12:06:04 AR 12:06:04
2014-10-01 16:01:30 Z 16:01:30
2014-10-01 17:06:25 N 17:06:25
2014-10-01 17:06:29 - 17:06:29

What I would like to achieve is as under:

Date Employee Name In Time Out Time
Day 1 Z 09:00:00 17:00:00
Day 1 N 08:30:00 17:10:00

Getting only 01 minimum time (In Time) & maximum time (Out Time) for each day in adjacent columns for 01 employee (ignore all other intermediate punch times).

Here's link to my worksheet: https://docs.google.com/spreadsheets...it?usp=sharing

I would be grateful if anybody could guide me please.

This solution uses simple formulae and cell formatting to produce the output that you indicate.
The times are simply equal to the times in column B and with the use of cell formatting get the date and time separated.
The employee list was created by copying column A and column J and pasting the copies to form a range. Then duplicates were deleted using the Remove Duplicates found on the Data tab. This table was then used in a VLOOKUP to assign employee names to match the IDs.

I have included a Pivot table to summarize your data grouping daily data.