Forum Discussion
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...
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.
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.
It worked! Thank you again for your answer, it helped me a lot!