Daily Time Record

Hi,

I got a raw data here, and must be format in this way.

EmployeeCode / TimeInAM / TimeOutAM / TimeInPM / TimeOutPM

Seems that many employees makes log more than 2 times for morning and more than 2 times in afternoon. So all we need to do is to get only the first and last punch for morning which is (6:00am until 1:30pm) and afternoon for (2:00pm - 10pm).

"Heres the Raw Data"
Please note that i have only 3 columns here. whew! thats is my big problem.)

EmpCode_Column Date TimePunched
001 1 0645
001 1 0933
001 1 1300
001 1 1502
001 1 1815
001 1 1903

========================================================
How can i achieved this result:

EmpCode / Date / TimeInAM / TimeOutAM / TimeInPM / TimeOutPM
001 / 1 / 0645 / 1300 / 1502 / 1903

=========================================================

Please help me.
Thank you very in advance.

JB


Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories