Vacation Tracker for 9/80 and 4/10 Workers

Hello,

I recently inherited a vacation tracker that is tracking vacation days. Works great, for counting days, but I have employees who work a 9/80 or 4/10 schedule, therefore their vacation time should be summed in hours.

I just cannot seem to fit into the formula a summing of the numbers to determine number of hours vacationed. Can someone explain to me what this formula is doing?

Current count of monthly days
{=SUMPRODUCT((OFFSET($A10,0,31*($A$3-1)+1,1,31)<>"")*(IF(OFFSET($A10,0,31*($A$3-1)+1,1,31)=$NR$12,0.5,IF(OFFSET($A10,0,31*($A$3-1)+1,1,31)=$NR$13,0.5,1))*(OFFSET($A$6,0,31*($A$3-1)+1,1,31))))}

Current count of yearly days
{=SUMPRODUCT((OFFSET($A10,0,1,1,372)<>"")*(IF(OFFSET($A10,0,1,1,372)=$NR$12,0.5,IF(OFFSET($A10,0,1,1,372)=$NR$13,0.5,1))*(OFFSET($A$3,0,1,1,372))))}

I'm sure once I understand what these formulas are doing, these Excel functions will become extremely helpful for me in other worksheets. File Forum - Maintenance Vacation Scheduling - 2021 uploaded. Thanks in advance for the lesson .

Reminder: My objective for the workbook is to sum the number of vacation hours. Thank you .

Thank you AliGW. I'm aware of how the site works. It's been a while since I posted an item. Any help at any time will be greatly appreciated. In the meantime, I'm still trying to figure out the code. Should I find the solution prior to receiving a response via this forum, I'll be sure to post it. I could be the one helping someone else !

JeteMc...you are the best! You are correct in your observation of the entries being alphabetic originally. Thank you for the help. Your recommendations give me exactly what I'm looking for. Much thanks!!!

Solved