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.
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.