Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excluding week-end days/hours
Can somebody help me to get me on track for the following. To do some
'action-reaction' calculation via a VBA macro I need to exclude week-end days/hours out of my result. Please find below an example with the criteria that should be taken into account. Action date Reaction date Hours without week-end 5/aug/2004 9/aug/2004 ? hours 9/aug/2004 22/jul/2004 ? hours Conditions to be taken into account a - VBA macro should exclude week-end days - Week-end starts Friday after 5.00 o'clock PM and ends on Monday 08.00 AM Many thanks for anybody who had already some VBA experience in this area. B.rgds, MC |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I calculate a week days hours with the 24hour clock | Excel Worksheet Functions | |||
Converting total number of hours (24 hours) into days | Excel Discussion (Misc queries) | |||
Re Change 5 week days to 7 days in this formula | Excel Worksheet Functions | |||
how to chart data spread over 24 hours a day and 7 days a week? | Charts and Charting in Excel | |||
How do I calculate the week day hours between 2 days | Excel Discussion (Misc queries) |