=IF(A1:A10="t","=NOW","")

[Alizakore]

What's wrong with this formula? In row A1:A10 if i write t it gives =NOW but not the FORMULA for showing time. What is the mistake here?
Thanks!

 

[Marcílio_Lobão]

Alizakore, Good afternon.

Try to use:

=IF(COUNTIF(A1:A10, "t")>0,NOW(),"")

Remember to format as TIME the cell will receive this formula.

Is that wha tyou want?

I hope it helps.

 

[Alizakore]

Hi Marcílio, thanks for replying!
There is something wrong with the formula you posted.

 

[Marcílio_Lobão]

Alizakore,

What kind off error are appearing?

It's a very simple formula.

 

[Alizakore]

Alizakore,

What kind off error are appearing?

It's a very simple formula.

Hi,
I get the following error:

https://imgur.com/a/J9QAa

 

[Marcílio_Lobão]

Alizakore, Good evening.

The error message is clear.

You're typing a formula as text.

Did you used CTRL+C and CTRL+V with the suggested formula here and put it at a cell directly?
It's so simple.

To avoid getting too much time to solve something that is apparently simple, save your spreadsheet on a free website, www.sendspace.com or another and place the download link here.
This will make it easier to check what's going on with your data.

 

[JumboCactuar]

Can you not just place this in B1 and drag down?

=IF(A1="t",now(),"")