| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
simple date and time functions
Hello. I am trying to compare the difference between two dates and times
based on a 24 hour structure, including the NETWORKDAYS function. We work on a 48 hour turn around. Document comes in at 10:00 on 12-06-2005 and out 12:00 12-08-2005 then "no" else "yes". Specific formatting for dates and times seem to be an issue in NETWORKDAYS where I get the correct date calculation, but when I enter in the holidays, it returns a VALUE#. I have used mm-dd-yyyy. Thanks in advance for your help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to calculate Date & Time differences | Excel Worksheet Functions | |||
| Using VLOOKUP with a Date and Time | Excel Discussion (Misc queries) | |||
| How do I calculate if a date is in a certain time frame? | Excel Worksheet Functions | |||
| Imported Date & Time format with calcs. managed in excel from imrp | Excel Worksheet Functions | |||
| Help - Information with time and date | Excel Discussion (Misc queries) | |||
Threaded Mode
