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.
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.
0 · ·