Forum Discussion

Copper Contributor

Jan 26, 2022

Solved

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

Formulas and Functions

Riny_van_Eekelen
Jan 26, 2022
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.
Night Shift Sample.xlsx554 KB

chahine

Iron Contributor

Jan 26, 2022

can you send small portion of file so we can try something

ronaldonaire
Copper Contributor
Jan 26, 2022
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
- Riny_van_Eekelen
  Platinum Contributor
  Jan 26, 2022
  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.
  Night Shift Sample.xlsx554 KB
  - ronaldonaire
    Copper Contributor
    Jan 26, 2022
    Riny_van_Eekelen Thank you for your answer I have tried it and it works! Can you tell me how did you split your created Clock IN row to be able to show minutes, hours and Days? I can't recreate what you did here.