<tbody>
in
8:00
8:00
out
12:30
12:15
in
13:30
13:15
out
17:30
total
8:30
6:37
15:37
15:37
</tbody>
function for the first total (in cell B10)=IF(ISBLANK(B6:B9),"0",IF(ISBLANK(B7:B9),NOW()-B6,IF(ISBLANK(B8:B9),B7-B6,IF(ISBLANK(B9),(NOW()-B8)+(B7-B6),(B9-B8)+(B7-B6)))))...