Aug 30 2022 11:14 AM
I am trying to keep track of the vacation hours my employees take. Excel has a good program that helps you count each quarter separately. However, this formula below means if I put a V in the space it turns it purple and a count of one in the total column. I actually need it to let me put in V-8 or V-4 so I can keep track of the actual hours.
Maggie
Aug 30 2022 11:59 AM - edited Aug 30 2022 11:59 AM
SolutionSep 01 2022 10:34 AM
Sep 01 2022 11:07 AM
Try this. If you don't have Microsoft 365 or Office 2021, confirm the formula with Ctrl+Shift+Enter:
=SUM(IF(LEFT($E7:$CP7,2)="V-",-MID($E7:$CP7,2,10)))
Aug 30 2022 11:59 AM - edited Aug 30 2022 11:59 AM
SolutionPerhaps
=8*COUNTIF($E7:$CP7, "V-8")+4*COUNTIF($E7:$CP7, "V-4")