Thread
:
If Between 2 Times
View Single Post
#
4
Don Guillett
Posts: n/a
Have a look in HELP index for AND to get the proper syntax
--
Don Guillett
SalesAid Software
"Richard - ExcelForums.com"
wrote in message ...
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!
Reply With Quote