February 10, 2020
Good morning everybody!
I have tried to write an if/then statement using tables. i am new and really trying.....I have just learned how to create a table so I have three tables - employeename - labortype and totalhours. I am trying to keep track of employees, by name, what number they use to charge their labor and total number of hours of labor they submit that week. I download an excel spreadsheet, have the columns named as tables but i can't figure out how to differentiate by name. Do i need to add a different name in each formula? That would take quite a bit of work with several employees.
So, I have a column name employeenumber, employeename, their labor 'labortype' , a column with the total number hours of labor ('totalhours' they may charge different numbers to different labor types ,ie if they work on different projects within the company they need to charge to that project). that is what is giving me issues. They also report RG, OT, etc and i would love to have that also, another column, but at this point i will be very happy to figure out the total number of hours per employee per week.
I'm thinking if i could possible write a if or (maybe if/then) stating pick up 'employee name' check the 'labor type' and 'total hours and dump this in a spreadsheet. Does this make sense? Am i asking excel to do too much?
So I want it to pick up John Doe, labor type 10000555, total hours 8 - but also pick up John Doe, who also turned in labor type 1000655, total hours 4. Is this even possible?
thanks in advance! Really, really will appreciate any and all help!