LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Hourly calculation

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.

MC



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
hourly average help bob New Users to Excel 10 July 5th 09 12:05 AM
How to convert half hourly data into hourly kippers Excel Discussion (Misc queries) 5 February 1st 07 10:27 AM
Calculation of hourly rate times hours times 1.5 Newbusinessbod Excel Worksheet Functions 1 December 6th 05 04:44 PM
Hourly rates Dreamstar_1961 Excel Worksheet Functions 3 November 2nd 05 11:33 AM
How can I do an hourly salary calculation in Excel AndyM Excel Discussion (Misc queries) 2 September 15th 05 05:29 AM


All times are GMT +1. The time now is 10:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"