Saturday, June 23, 2018

yogi_add values up from a data (from to hours) validation drop down box

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.


Many Thanks
Kyle