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

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.

thanks a million for your assistance.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top