I have a time card where I would like to total regular hours, Holiday hours, vacations hours, etc. The hours for each day can fluctuate so the type of hours, if different than regular, are labeled as 'Holiday', 'Vacation', etc.
Im able to use the Index Match to get the number of hours to show correctly for one 'Vacation' match, but can't seem to get addtional 'vacation' days added into the total.
Does anyone have a suggestion? Thanks for helping!!!!!
Example
hours Type
9
7.5 vacation
9 vacation
8
8 holiday
8
9
6 PTO
7.5
4
__
Regular hours 45.5
Vacation hours 16.5
Holiday Hours 8
PTO hours 6
Total hours 76.0
Bookmarks