Hello all.
I am trying to create a worksheet that will automatically sort data I wish to copy and paste. I'm using a software that calculates employee's working hours - and specifics according to which company job they are working on. I am able to get a report of the data in an excel worksheet - however it's all a little messy, with blanks and duplicates.
Here is an example of what the report looks like...
EG1.PNG
EG2.PNG
EG3.PNG
This is what I want to achieve...
Name - Total Hours Worked – Hrs ETAVONI CUSTOMER – Hrs TRUARC CUSTOMER – Hrs FRESHLOOK CUSTOMER – Hrs Not Assigned - Un-booked time - Percentage not assigned - Percentage un-booked time
DANIEL WILSON 30 0 11.57 0 12.37 6.06 41.2% 20.2%
DAVID PORTER 39.5 0 35.40 0 0 4.10 0 % 10.3%
Fields I want in the database -
Total Hours worked
Etavoni hours
Truarc hours
Freshlook hours
Hours not assigned
Un-booked time
Percentage not assigned
Percentage un-booked time
This database will determine what employees are paid so it's vital I get it correct.
Are there any suggestions to which formula/conditional formatting/rules I can use that will help reduce the amount of fields to just one employee. (at the moment the report shows multiple jobs, I want to be able to tell excel that one employee's name is how to group the hours together) is this possible?
Thank you
Bookmarks