'Time' reference

[Adam Kelly]

From an Excel novice;

I want to use the COUNTIF function to count the cells in a range. The range contains only 'times', e.g. 20/07/2011 17:06:44, and I want to count cells which contain times which fall AFTER a specified time. The specified time will be regularly changed.

I've managed all this so far, but I want the SPECIFIED time to be a reference to a cell rather than typing in a new time - an example of the reference cell would be '=now()-.5' (for 12hrs ago)

so... if, for example, cell A1 contains '=now()-0.5'...

The following WILL work:
=COUNTIF('Downtime Record'!B6:B126,">40744.17")

but this wont:
=COUNTIF('Downtime Record'!B6:B126,">A1")

does that make sense? - any ideas?

Thankyou in advance

 

[VoG]

Try

=COUNTIF('Downtime Record'!B6:B126,">"&A1)

 

[Jonmo1]

Try
=COUNTIF('Downtime Record'!B6:B126,">"&A1)

 

[Anne Troy]

Try

=COUNTIF('Downtime Record'!B6:B126,">"&A1)

VoG, you have helped me yet again. I looked all over the web for this. I thought the ">A1" would be the syntax, but you nailed it again.

Thanks tons!