Calculating available hours based on multi-select dropdown
I'm working on building out a scheduler for people; on the signup form, they have options like:
Monday 8a - 12p
Monday 12p - 4p
Monday 4p - 7p
...and so on through Friday, plus some Sat/Sun weekend shifts.
What I'd like to do is calculate the Total Available Hours and use that as a reference point to pull from after 30min sessions have been booked.
So far I've set up a vlookup sheet where the first column are the criteria, and the second column has the included number of hours e.g., 4 for Monday 8a-12p.
Then in the original sheet, I've used COUNTM to count the number of shifts available.
Is it then possible to somehow combine those two in order to multiply # of shifts * vlookup of the hours within said shifts?
Or is there an easier way? :D
Help Article Resources
Check out the Formula Handbook template!