Forum Discussion
Power Query Time Detail Report Rows
Hello, I've been trying to setup a query to on a time detail report where each set of punches is on a different row. Originally we were accomplishing this with pivot tables, but recently noticed ...
Thank you for your reply. I have updated the post with an example of the data. I usually start with filtering Time Code to contains WRK
JamesMcQueen Not sure what kind of summary you have in mind mind. But perhaps something like in the attached file.
Riny_van_Eekelen Thank you again for the assistance. I have attached a snippet of the how I'm trying to make the end result look like. For the the report that this data will be injected into I will need to show the start and end time punch's. and the max end time since the OT adds an additional clock in for some reason.
JamesMcQueen So, when an employee has punched in and out 4 times during the day, you want 8 columns with these 4 start and 4 end times?
- No just 4 columns for the punches. ClockIn (first StartTime for the day), LunchOut (first EndTime for the day), LunchIn (2nd StartTime for the day), ClockOut (Max EndTime for the day)
