I have a bunch of times in one column. I want to see how long each time segment is. Example:

7:54 |

10:07 |

11:02 |

8:06 |

<colgroup><col></colgroup><tbody>

</tbody>

All that data is in Column B. Need your help to do this:

Formula should go in C2 and "basically" take the difference between B3-B2

*but*only adds the work hours. So, if I work from 11:02 on day 1 to 8:30am the next day, I worked 3h49m or with proper formatting: 3:49 is the true difference. That's what I need the formula to be able to do on the overnight shifts. Here's more info if it clarifies:

You can see taking the difference between 7:54 and 10:07, and also the difference between 10:07-11:02 is easy. The one I need your help with please is this: In going from 11:02 to 8:06, my shift time length would be:

**(1:15pm - 11:02) + (8:06 - 6:30)**= 3h49min or "3:49".

So, that part in bold represents the idea I need to formulate with your help for time segments that go from one day to the next.

*Another way to put it is that for successive times that go from (some time before 1:15pm on day 1) to (some time after 6:30am on day 2) should have that more complex formula. Otherwise, it's just the cell-to-cell difference*.

Thanks for helping out.