| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
difference between two dates and before a certain time
I have two columns of dates and I need to know if the 2nd column happened
before 8am of the second column date. So, I have 01/01/09 18:34 in the first column and in the second column I have 01/02/09 09:17. What formula can I use to show that the date/time in column 2 is no later than 08:00 the following day of the first column? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Difference between 2 dates&time(format 0000), and excludes weekend | Excel Worksheet Functions | |||
| subtract the time difference from another time difference | Excel Discussion (Misc queries) | |||
| Time difference calculations, daylight savings time, Excel | Excel Discussion (Misc queries) | |||
| Negative time should be allowed in Excel, eg time difference | Excel Discussion (Misc queries) | |||
| HOURS DIFFERENCE IN TIME BETWEEN DIFFERENT DATES AND TIMES | Excel Worksheet Functions | |||
Threaded Mode
