You're making things difficult for yourself by trying to have the start & finish times in the same cells. Is there a good reason you can't have them on separate rows? Do that and use another row for the daily calculation, which becomes quite simple (eg: = MIN(A3-A2,8))

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Hi Paul, thanks for replying.

Honestly, it never occurred to me to have an IN column and an OUT column, like a time card for a time clock. I should have thought of that to begin with.

Not a big deal to have those columns.

Now, I just have to figure out how to create the formula for it. Thank you. Jd