| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I subtract 8 business hours from a date/time value?
I am trying to subtract 8 hours from a date/time. What I need to do is to
capture that lead time using only weekdays, and working hours of 8am-5pm. For example: Date/Time 6/23/2008 9:18AM (Monday) Subtracting 8 hours from this scenario would give me 6/20/2008 10:18AM (friday) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time/Date subtract 24 hours | Excel Discussion (Misc queries) | |||
| Date and Time Response- before/during/after Business hours | Excel Discussion (Misc queries) | |||
| How do I add 12 business hours to the current date/time? | Excel Worksheet Functions | |||
| How do I add 12 business hours to the current date/time? | Excel Worksheet Functions | |||
| Time and Business Hours | Excel Worksheet Functions | |||
Threaded Mode
