Share via

If column 5 contains OT, then column 6 should return the number contained in column 4. The rows that don't return a value, will be empty. So then I can add up all the overtime hours. Thank you!

Anonymous
2025-03-21T22:55:24+00:00
Date Name Payroll Item Duration Notes
1 2 3 4 5 6
10/07/2024 O'NEILL, COLIN Regular Hours - Garage 1.00 #3880  FIX COOLANT HOSE/LEAK  A016
1.00
09/21/2024 O'NEILL, COLIN Over Time - Garage 1.00 OT  #3840  CHNG OIL, FILTER, AIR FILTER  A018
10/01/2024 O'NEILL, COLIN Regular Hours - Garage 0.50 #3861  NEW TIRES  A018
10/24/2024 O'NEILL, COLIN Regular Hours - Garage 1.00 #3936  HELP DARRYL WITH REPAIRS  A018
2.50
Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2025-03-21T23:07:04+00:00

Hi there

Please, try the formula

=IF(ISNUMBER(SEARCH("OT",E2)),D2,"")

I hope this helps you

Regards

Jeovany

Was this answer helpful?

1 person found this answer helpful.
0 comments

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2025-03-24T22:47:56+00:00

    Thank you for your quick reply, and for the formula! Janet

    Was this answer helpful?

    0 comments
  2. Anonymous
    2025-03-24T22:45:32+00:00

    Thank you for your quick reply, and for the formula! Janet

    Was this answer helpful?

    0 comments
  3. HansV 462.6K Reputation points
    2025-03-21T23:00:47+00:00

    In F2:

    =IF(IFERROR(SEARCH("OT", E2), 0)=1, D2, "")

    Was this answer helpful?

    0 comments