I am have a set of data that includes equipment downtime (in hours) and it is tied to a specific start date when the equipment first had a breakdown. In some instances the downtime may be greater than 24 hours, so the full hours are being recorded on one day (in attachment "equipdowntime.png" below see date 4/22/13 - downtime is 618.75 hours).
I need to figure out how to breakout the downtime so that the 618.75 hours would be spread across the next consecutive days in 24 hours increments until the full downtime is met. (see example "end result.png") The only other factor that needs to be considered is if there is already a downtime in one of these dates (see 4/23/13 on the "equipdowntime.png" where it shows a 2 hour downtime) then this should be ignored and only show the 24 hour downtime (not 26 hours downtime or 24 hours and 2 hours of downtime)
I have very limited coding experience so any help would be greatly appreciated! Thanks.
