This should be simple for anyone who has any experience with excel formulas (I have none!).
I've got a spreadsheet that lists the dates in each payperiod. In each cell we will track whether time off is taken as PTO or Vacation and the number of hours. What I want is at the end of the pay period for the formula to tell me how many hours total for each group (PTO or Vacation). Here's what my sheet looks like:
12 13 14 15 16 19 20 21 22 23 Totals
Employee Name 8v 8p 8v 8v
So in the totals column, I want it to tell me how many total hours are shown for vacation and how many total hours are shown for pto. Obviously, the answer should be 24v and 8p, I just can't figure out how to get it there.
Any help would be appreciated! Merry Christmas!
I've got a spreadsheet that lists the dates in each payperiod. In each cell we will track whether time off is taken as PTO or Vacation and the number of hours. What I want is at the end of the pay period for the formula to tell me how many hours total for each group (PTO or Vacation). Here's what my sheet looks like:
12 13 14 15 16 19 20 21 22 23 Totals
Employee Name 8v 8p 8v 8v
So in the totals column, I want it to tell me how many total hours are shown for vacation and how many total hours are shown for pto. Obviously, the answer should be 24v and 8p, I just can't figure out how to get it there.
Any help would be appreciated! Merry Christmas!