| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Checking time and inserting a value in a different cell
I have Column H that has been formatted as time (i.e. 1:30 PM).
If the value in column H is Less than 07:30 and Greater than 15:30, I would like the number 41079 populated in the appropriate cell in column J. If the test is not False, I would like the value 41078 populated. I have inserted the following formula in H6 €˜=IF(H615:30 and <7:30,41078,41079), however when I depress the enter key J6 displays #NAME. Can you help? Thanks Pank |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to insert an empty row at the same time in more than one sheet? | Excel Discussion (Misc queries) | |||
| Inserting time in cell to the right | Excel Worksheet Functions | |||
| More problems displaying a negative time | Excel Discussion (Misc queries) | |||
| How to exclude weekends/holidays from plotted time series | Charts and Charting in Excel | |||
| Time & Date Formatting | Excel Worksheet Functions | |||
Threaded Mode
