Forum Discussion
tyjames05
Helper I
2 years agoSeperating specific working hours from total hours column
Hello all, I have a column that has the total for hours worked for each day. In each day there could be 3 different process requiring working hours. Assemblies, CTL's and PF. When I add "Total Wo...
tyjames05
Helper I
2 years agoI appreciate the response. I will figure out how to get rid of peoples names and what not. I did find a solution of sorts by using Power Query. I basically made a 3 duplicates of my dataset and then used only the columns that contained each type of work hours. I then turned all of "null" values in 0s and filtered each column to eliminate rows that didn't have any value.
I will upload my report this weekend because I'm sure theres a better way of doing this.