I have a column (G) of rows from 1 to 6. I want to add that column,
however, sometimes one of the rows may have a number I need subtracted. How
can I come up with a 'hopefully' short formula to determine IF there is () in
any row of that column, to subtract it. Such as:
row1: 8:00
row2: 6:00
row3: 3:00
row4: (9:00)
row5: 5:00
row6: (7:30)
should equal 5:30
But another time it might be row2 with the () or row 3 and 5.
Or should I use - instead of ()?