Hi
=IF(AND(C1=A1,A2<=B1),"Between","not between")

--
Regards
Frank Kabel
Frankfurt, Germany

Richard - ExcelForums.com wrote:
Hello,

I am trying to find out if a cell is between 2 times.

A1 = 06:00
B1 = 10:00

A cell will represent 15 minutes. So the cell will display a number if
the cells number (say 06:15) falls between or is equal to anyof
these.

i.e. =IF(A1<="06:15" AND B1="06:15", "true", "false")

Cheers
Richard
---------
www.coffeecozy.com

Use your Bodum and give up cold coffee for good!