Start Time to End Time... Minutes On Each Hour... How to distribute proportionately?

  • Thread starter Thread starter SVCitian
  • Start date Start date
S

SVCitian

For example:
I have a start date in A1: 19/09/2010
I have a start time in B1: 05:36
I have an end time in C1: 08:59
I have a number in D1: say 13050

end time could be next day.. but not greater than 24 hours from start
time.
And, I have 100s of rows with different times

I want to use vba to do this..

In another sheet:
Date, 00, 01, 02, 03, .... 23 (representing 23 hours)

For the above data,
0500 to 0600, 24 minutes used
06 to 07, 60 minutes used
07 to 08, 60 minutes used
08 to 0859, 59 minutes used
Total Time Elapsed.. 203 minutes 100%.. (with 13,050 from D1)


And I want to share 13,050 on each hour according to the above
proportion.

in Column 05, 1542.86
in Column 06, 3857.14
in Column 07, 3857.14
in Column 08, 3792.85

So, the 2nd sheet should be populated with above numbers for each of
the corresponding hours in that columns and for the correct date.

How to distribute the 13,050 by proportion for each hour.. using vba.

thanks a million for your assistance.
 
Why has it got to be vba? You didn't get any answers from the
programming group the other day.

Pete
 
Yes.. didn't get any reply..

I prefer vba, so that I have finer control.. and modify further. also
need to exclude for some special cases and do different proportions.
 
Back
Top