Idle time

Hello all,

Is this possible??

As in the attached example sheet can we find time difference of an individual when he finishes a work and time when starts new one.

xxx starts at 4:24 pm(B column) and completes at 6:00(C column).And next he starts at next day 4:24.
i have to calculate diff btw c3 and b7 considering working hrs as (9:00 to 6:00)

this case it was easy we could mannualy write formula

what if there are too many people?

Maybe this:

=VLOOKUP(A3, A4:B1000, 2, FALSE)-C3