I have a formula in F3 of my spreadsheet that automatically updates date and time every time cell B3 is updated. When F3 updates a time is automatically kicks of a 24 hour countdown in G3. When I manually update the value in B3, it all works fine in G3 and F3. However, I want the value in B3 to be a formula. So when I make B3 be a formula, it doesn't work in G3 and F3. G3 just changes to 1/00/00 12:00:00 AM and the countdown doesn't start. How can I get G3 to work when B3 is from a formula?
Or is there a way I can put a string of cells into F3 that I can update manually? I tried changing B3 in the formula of F3 to be something like J3,K3,L3 or J3:L3 but neither worked.
F3 formula is =IF(B3<>"",IF(AND(F3<>"",CELL("address")=ADDRESS(ROW(B3),COLUMN(B3))),NOW(),IF(CELL("address")<>ADDRESS(ROW(B3),COLUMN(B3)),F3,NOW())),"")
G3 formula is =IF(F3+"24:00:00">NOW(), F3+"24:00:00"-NOW(),0)
Thanks for any help you can provide
Let me know if you require any more information.
Or is there a way I can put a string of cells into F3 that I can update manually? I tried changing B3 in the formula of F3 to be something like J3,K3,L3 or J3:L3 but neither worked.
F3 formula is =IF(B3<>"",IF(AND(F3<>"",CELL("address")=ADDRESS(ROW(B3),COLUMN(B3))),NOW(),IF(CELL("address")<>ADDRESS(ROW(B3),COLUMN(B3)),F3,NOW())),"")
G3 formula is =IF(F3+"24:00:00">NOW(), F3+"24:00:00"-NOW(),0)
Thanks for any help you can provide
Let me know if you require any more information.
