With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Saturday, June 23, 2018
yogi_add values up from a data (from to hours) validation drop down box
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.