adding different categories of the drop down menu
Our take
I am trying to make a google sheet where I am tracking clinical hours for my masters program. I have a column that is a drop down menu with two different categories in column B (direct and indirect). I also have a column that calculates the amount of hours from row D and E. I want to find a way keep track of each category ie direct and indirect separately. Essentially I want to find a way to add amount of hours from column F for solely direct and indirect.
Not sure if this is something that can be done, but my ideal way would be to have a separate cell outside of the table that just adds the hours together when I put in more information in a row.
Not sure if its important but column F is:
=IF(ISBLANK(D2),"",IF(ISBLANK(E2),(NOW()-TODAY()-D2)*24,(E2-D2)*24))
[link] [comments]
Read on the original site
Open the publisher's page for the full experience