How to start to recount once a condition is met?
TTTTT.PNG
When Normal Room is 0, Then Duration(min) will increase by 10.
However, when Normal Room is "blank", Then Duration(min) will recount from 0 until Normal Room is NOT "blank".
However, I want to remain the count previously afterwards.
Just like the photo attached, when it detects Normal Room is "blank", it will overwrite and start recounting. But when it detects Normal Room is NOT "blank". , it will resume previously.
Last edited by PeterHan123; 02-24-2021 at 12:14 AM.
if we assume headers in row 1 then one option:
E2: =IF($F2<>"",10*(ROWS(E$2:E2)-1),IF($F1<>"",0,$E1+10))
copied down
the above would replicate the results per your screenshot.
It works. Thank you so so much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks