Ya, sorry, two different days and things change. So, let's do 10 hours. I kinda did a workaround by just extending the time out for 48 hours by using a formula, which worked, not ideal, but worked. BUT, formulas I was using elsewhere quit working properly and for the life of me couldn't figure it out. So I copied my problem exactly to a blank spreadsheet to present on here but it worked fine. Took a while but I figured it out, any duplicate times, the serial number would change which is what Excel uses in the formula, so for example, the first instance of 3:00 is 0.125, but the second instance of 3:00 returns 1.125, which is a problem in formulas! So what I figured out was to break the formula at 0:00 and start over, then Excel won't add the 1. This works, but you end up with such a long list to scroll thru, so a much shorter, eight hour list that moves, so no matter what time you start with, you always have an hour or two past the end of shift, so for a eight hour shift, one would need to have ten hours in the list.