Daily Time Record - Programmers Heaven

Howdy, Stranger!

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

Categories

Daily Time Record

jbburayagjbburayag Posts: 1Member
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.