lightningmtv
New Member
- Joined
- Nov 1, 2022
- Messages
- 3
- Office Version
- 2021
- Platform
- Windows
Hello,
I’m trying to create a formule that adds a given time to a total only if the checkmark in the collum next to it has been checked off.
Example
Colum F has
F2: 11:30
F3: 2:30
F4: 4:30
Colum G has
G1: Not checked
G2: Checked
G3: Checked
Will give a total of 7 hours.
Hope someone can help
I’m trying to create a formule that adds a given time to a total only if the checkmark in the collum next to it has been checked off.
Example
Colum F has
F2: 11:30
F3: 2:30
F4: 4:30
Colum G has
G1: Not checked
G2: Checked
G3: Checked
Will give a total of 7 hours.
Hope someone can help