i have 2 columns, No1 is "status", No2 is " workingtime", i need a formula calculate workingtime ( date or hour) thru conditon at column "status" : if column "status" = "active" then column count up, if column "status" = "stop" then column pause count up . please help me. Thank so much
User | Count |
---|---|
15 | |
12 | |
9 | |
8 | |
4 |