Time Stamp and Countdown formula

%3CLINGO-SUB%20id%3D%22lingo-sub-1083531%22%20slang%3D%22en-US%22%3ETime%20Stamp%20and%20Countdown%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1083531%22%20slang%3D%22en-US%22%3E%3CP%3EI%26nbsp%3B%3CSPAN%3E%26nbsp%3Bhave%20a%20formula%20in%20F3%20of%20my%20spreadsheet%20that%20automatically%20updates%20date%20and%20time%20every%20time%20cell%20B3%20is%20updated.%20When%20F3%20updates%20a%20time%20is%20automatically%20kicks%20of%20a%2024%20hour%20countdown%20in%20G3.%20When%20I%20manually%20update%20the%20value%20in%20B3%2C%20it%20all%20works%20fine%20in%20G3%20and%20F3.%20However%2C%20I%20want%20the%20value%20in%20B3%20to%20be%20a%20formula.%20So%20when%20I%20make%20B3%20be%20a%20formula%2C%20it%20doesn't%20work%20in%20G3%20and%20F3.%20G3%20just%20changes%20to%201%2F00%2F00%2012%3A00%3A00%20AM%20and%20the%20countdown%20doesn't%20start.%20How%20can%20I%20get%20G3%20to%20work%20when%20B3%20is%20from%20a%20formula%3F%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EOr%20is%20there%20a%20way%20I%20can%20put%20a%20string%20of%20cells%20into%20F3%20that%20I%20can%20update%20manually%3F%20I%20tried%20changing%20B3%20in%20the%20formula%20of%20F3%20to%20be%20something%20like%20J3%2CK3%2CL3%20or%20J3%3AL3%20but%20neither%20worked.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CBR%20%2F%3E%3CSPAN%3EF3%20formula%20is%20%3DIF(B3%26lt%3B%26gt%3B%22%22%2CIF(AND(F3%26lt%3B%26gt%3B%22%22%2CCELL(%22address%22)%3DADDRESS(ROW(B3)%2CCOLUMN(B3)))%2CNOW()%2CIF(CELL(%22address%22)%26lt%3B%26gt%3BADDRESS(ROW(B3)%2CCOLUMN(B3))%2CF3%2CNOW()))%2C%22%22)%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EG3%20formula%20is%20%3DIF(F3%2B%2224%3A00%3A00%22%26gt%3BNOW()%2C%20F3%2B%2224%3A00%3A00%22-NOW()%2C0)%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EThanks%20for%20any%20help%20you%20can%20provide%3C%2FSPAN%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%26nbsp%3BLet%20me%20know%20if%20you%20require%20any%20more%20information.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1083531%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Regular Visitor

 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.

0 Replies