I'm trying to figue out a formula to use on a condition: I have a sheet "Admin" where I put code letters, and each code letter represent a time. For example: P = 00:15; Q = 00:30; R = 01:00; S = 01:20 On the next sheet "Activities", I created a monthly tracker. Under the date, I've added a drop down menu with the code letters. What I'm trying to figure out is: how when I choose a letter (from the drop down menu), would return the time / minutes of that code letter. On my weekly tracker I have added a column, that would add up all the minutes, to show the total time at the end of each month.
Thank you for any help.