|
If Between 2 Times
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! |
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! |
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! |
| All times are GMT +1. The time now is 05:06 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com