Forum Discussion
Changing Date For Night Shift Employees
Hi Guys, I'm having a problem placing Employee logs in a single row due to changing dates the next day in their logs. I want to know if there's a formula I can use to set their login according to the Day they punched "In". Example:
Thanks Guys
ronaldonaire Just added one column to the time-log that determines the Clock IN time for each entry, based on the Break Type. Then, the pivot table can be like I inserted in the Final Data tab, from row 16.
6 Replies
- can you send small portion of file so we can try something
Hi! Sorry I can't seem to find the attach file here but here's the sample file: https://drive.google.com/drive/folders/14yz9gNmUlOwQbq4h43nRGE1nKq_YY1iz?usp=sharing
ronaldonaire Just added one column to the time-log that determines the Clock IN time for each entry, based on the Break Type. Then, the pivot table can be like I inserted in the Final Data tab, from row 16.
