Google Spreadsheet Post #2464
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI Jun-22-2018
question by: kyle hoelger
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/KOhWMJqU6cE;context-place=forum/docs
How to add values up from a data validation drop down box?
Hi,
I have created a rota with data validation drop down boxes with the times I went my team to work, at the end of the week in a separate column I wanted to add up how many hours that staff member has worked. so example is 8:00am - 16:00pm is 8 hours shift but i cant work it out how to get that cell which contains the value 8:00 - 16:00 to equal a number for example 8 hours.
What I would like it to do is be able to use the data validation so I can drop down the times for each staff member and it all adds up the total hours worked in end column.
Is there a way to make this happen?
I have attached a link to my document but all personal data has been taken out of it for reference.
https://docs.google.com/
Many Thanks
Kyle
No comments:
Post a Comment