| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create formula-if value A falls between values B and C in time for
Struggling how to create a formula to check if a value falls between two
others where one value is another calculation. My data is: A B C D 1 07:00:00 07:10:00 07:30:00 08:15:00 I want to say " if B1 falls between A1 and A1+15 minutes, then subtract A1 from D1. There are other conditions I have written that this will be added to. Look forward to an elegant solution. -- Thanks!! Don |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If time falls within time.. | Excel Worksheet Functions | |||
| Possible to create line chart with values not in all time periods? | Charts and Charting in Excel | |||
| Formula has to take Monday if due date falls on a Sunday | Excel Worksheet Functions | |||
| Countif if the value falls between 2 other values | New Users to Excel | |||
| Formula to determine whether number falls within range?? | Excel Worksheet Functions | |||
Threaded Mode
