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: 8
Default Distributing Estimated Hours over calendar working days.

The following example assumes work on weekdays and Saturdays
but not on sundays (from Week Worked Days) and Work day hours are
from 7:00 to 17:30 with half hour for lunch.
I want to master VBA logic and syntax with this problem.
How do I loop thru my calendar to distribute time as shown,
decrement the remaining hours and skip the non-working days ?

.. Week Hours Number Scheduled Start August 2006
Estim. Worked Per Of Date Time 18 19 20 21
Hours Days Day Men Fri Sat Sun
Mon
80 6 10 4 8/18 13:30 16 40
0 24

I hope this does not get garbled. Thank you for your help,
Wayne

 
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
Changing Hours in working Days Nemo[_2_] Excel Discussion (Misc queries) 6 March 9th 11 10:11 PM
converting working hours to days nigeo Excel Discussion (Misc queries) 2 July 7th 09 05:19 PM
distributing days KANDLEZ Excel Worksheet Functions 1 May 20th 09 02:01 AM
Calculating Working Hours, Days and Overtimes. [email protected] Excel Discussion (Misc queries) 1 May 13th 08 02:18 PM
Working days and hours calculation - request assistance please! sbickley Excel Worksheet Functions 0 August 16th 06 06:37 PM


All times are GMT +1. The time now is 12:28 PM.

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

About Us

"It's about Microsoft Excel"