Hi,
I cannot figure out a formula to determine how to calculate time spent in a half hour interval, when the time is overlapping. To exemplify, [Cell A1] has a start time of 12:07am: [Cell b2] has an end time of 12:37 am. I need to calculate how much time of this duration was spent between 12:00am and 12:30 am; 12:30 am and 1:00 am. Obviously, I can do this manually. However, I have thousands of rows that I need to calculate the duration of certain states in a call center were spent by half hour interval. Any advise would be greatly appreciated.