Howdy, Stranger!

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

Sign In with Facebook Sign In with Google Sign In with OpenID

Categories

We have migrated to a new platform! Please note that you will need to reset your password to log in (your credentials are still in-tact though). Please contact lee@programmersheaven.com if you have questions.
Welcome to the new platform of Programmer's Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use its exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.

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.