Macro to conditionally insert and alter rows

[priceja12]

Good morning,
I'm looking to break time records into 30 minute buckets. Example: 8:00a - 9:00a 60 min should become two rows: 8:00a-8:30a 30 min and 8:30a-9:00a 30 minute. I'll then make a pivot to summarize the buckets. If a row has a 30 minute record, leave it. If it is 60 minutes, break into two 30 minute records. If it is 90, break into three 30 minute records, and so on. Any help is appreciated.

[carlmon]

Here's a solid start. I'm leaving the office for the weekend and will finish the code once I get back, or if someone else wants to hop in that would be great.

Best,
Carlmon

Please Login or Register  to view this content.

[priceja12]

Thanks Carlmon. I'm new to macro development and will try and step through it. Additional insight is appreciated.
Jordan

[carlmon]

I made progress on this one (below). I'll leave you with the fun task of finishing the 120 minutes and adjusting the start times. If you get stumped, I'll finish it for you.

Please Login or Register  to view this content.

[priceja12]

Thanks, again, Carlmon. I ran it and it is certainly a good start - I'll see if I can step through the code and fill in the gaps.

[priceja12]

Carlmon, I was able to finish the buildout and get it running. Thank you!!

[carlmon]

That's awesome! I'm glad you were able to follow along