Let me start by saying that I've been able to get a lot of help from this forum just reading it. It's an amazing resource and has been helpful so many times.

Right now, I am trying to calculate the number of hours worked between a series of times.

In cell A2 I have a start time. In cell B2 I have an end time. In cells C2:C5 I have times that span the whole day. For each block of time in the day, I need to know how many hours of the total from A2:B2 were worked.

For example, if the start and end times are 6:00 AM to 5:00 PM, how many hours were worked between 6:00 AM and 9:00 AM, between 9:00 AM and 12:00 PM, and between 12:00 PM and 5:00 PM?

I have tried many things. Some have worked partially and many more not at all. Any suggestions would be greatly appreciated.