| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
USING THE NESTED IF FUNCTION TO SEE IF A TIME DATE VALUE IS T OR F
If time is between 7am and 11am = morning
If time is between 12pm and 5 pm = afternoon If time is 5pm and < 7pm = Evening If time is between 7pm and 11pm = Night If time is between 12am and 6am = midnite I am having trouble getting the time component of the "DATE TIME" 6/02/03 12:21 AM - to be evaluated by the formula. Any help would be greatly appreciated Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date formulas | Excel Discussion (Misc queries) | |||
| Date Function | Excel Discussion (Misc queries) | |||
| How do I calculate if a date is in a certain time frame? | Excel Worksheet Functions | |||
| help with date and time | Excel Worksheet Functions | |||
| Automatically enter date and time but only update once. | New Users to Excel | |||
Threaded Mode
