| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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! |
|
#2
|
|||
|
|||
|
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! |
|
#4
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Countif("between start/end times) | Excel Discussion (Misc queries) | |||
| Adding/Averaging Times in Excel | Excel Discussion (Misc queries) | |||
| Whats the function to count the total times a word is displayed | Excel Discussion (Misc queries) | |||
| How can use IF function more than 7 times in a cell | Excel Worksheet Functions | |||
| how do I get a calculation to repeat various number of times? | Excel Worksheet Functions | |||
Linear Mode
