Jan 25 2022 08:04 PM
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
Jan 25 2022 08:41 PM
Jan 25 2022 08:59 PM - edited Jan 25 2022 09:03 PM
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
Jan 25 2022 10:43 PM
Solution@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.
Jan 25 2022 11:52 PM
@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.
Jan 26 2022 12:27 AM
@ronaldonaire When I dragged the Clock IN field into the rows area, it automatically created fields for days, hours and minutes. Then I reformatted the pivot table and unchecked the Clock IN, Minutes and Hours fields.
Jan 26 2022 12:31 AM
Jan 25 2022 10:43 PM
Solution@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.