Formula using hours

  • Thread starter Thread starter Ali
  • Start date Start date
A

Ali

How can I create a formula that will say:

If this cell is higher than 9:01 but but lower than 9:04
show a number?

Thanks for your help!
 
Hi Ali,

=IF(AND(A1>TIME(9,1,0),A1<TIME(9,4,0),17,"")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Hi Ali!

Here's an example:

=IF(AND(A1>TIME(9,1,0),A1<TIME(9,4,0)),1,"")

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
I tried this and it does not work. It says the formula is
wrong why? I have everything the same!

Thanks again.
 
Hi Ali!

Three possibilities:

You copied it wrong :)
Your separators are different from mine (What do you use for decimal
point?)
You might have the wrong type of "

Reply with a copy and paste of the formula that you have entered and
are being rejected on; just put a ' at the beginning so that it enters
your formula as text.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top