Is it possible to be able to select multiple names from the employee list and still calculate their hours individually or does this exceed what excel can do?
For example, if I were to select Art, Cortez, and Jay in the same cell, then input 8 in the man hours cell, their total hours will each increase by 8.
49 freelancers are bidding on average $87 for this job
Dear client The answer is yes it is possible to select multiple names into a single cell and add their working hours from another cell but will be same working hours. Please contact me for further details. Roy
What you asked is very easy to do. Can do it in one hour. You just need to use text functions to separate the names and match them to the list to get their hours.
Dear I am an excel professional having hands on expertise in developing spreadsheets for analytical purpose i will do your project as per your requirements. BEST REGARDS