Start Time to End Time... Minutes On Each Hour... How to distribute proportionately?
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. |
All times are GMT +1. The time now is 08:59 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com