| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time - By 8am the next morning
I have two columns with date and times. I need a formula to show that the
date in the second column was no later than 8am the day after the date/time in the first column. For example: A1 04/05/09 14:35 PM B1 04/06/09 11:01 AM So using my explanation above, this would be "not compliant" with the scenario and I would like an "N" returned. A compliant example would be: A1 04/06/09 14:35 PM B1 04/07/09 07:30 AM Is there a formula for this? Thanks!!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I need to display "Good Morning" or "Good Evening" based on NOW() | Excel Worksheet Functions | |||
| Formula doesn't work this morning, but worked for 2 years now | Excel Worksheet Functions | |||
| Saturday morning cut and paste help | Excel Discussion (Misc queries) | |||
| Simple, Monday morning brain function | Excel Worksheet Functions | |||
| Simple, Monday morning brain function | Excel Worksheet Functions | |||
Threaded Mode
