| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate current time + 7 hours and skipping weekends
Let say is Friday at 8:00 PM. I want to add 7 hours to it and skip all
hours in Saturday and Sunday. Start adding calulating again at Monday at 12:00 AM (Monday Morning). Any help in this would be appricated. I have reviewed and reviewed things trying to figure this out. Eric |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| date and time [skipping weekends] | Excel Worksheet Functions | |||
| Track time to resolution (without including after hours on weekdays and weekends) | Excel Worksheet Functions | |||
| Calculate number of hours between dates and times excluding Weekends | 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 | |||
![Eric[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
