Excel VBA modules

Need someone proficient with Excel VBA to create a module that is able to to take data for total outages with the dates over which these occurred and break them down so that each individual day receives an equal share of the outage. Outages start throughout the day so some days will have an incomplete contribution to the total outage. I need two columns showing the outage over all the individual days so that I can then combine them in a pivot table.