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]
|