I have data that looks like this
Tue, 1/1/2012 1:00 am, 60
Wed, 1/2/2012 3:00 am, 120
Wed, 1/2/2012 2:00 pm, 190
Wed, 1/2/2012 5:00 pm, 30


What I would like to do is take the data and display it in a pivot table that will break anything over 60 in multiple rows. So, 120 will look like 60 at 3:00 am and 60 at 4:00 am. Then at 2:00 pm will have 60 then at 3 it will be another 60, then at 4 will have 60 and at 5:00 it will have 40.

Also, what if something starts at 11:00 pm and it takes 2hrs.

I think I can use the sum in pivot but I need to break the data first. Can u help?