how do i track time

[Jeff]

im trying to figure out how to subtract both time frames
from when i come to work to when i leave via formula.

i was going to do a now function but it wont subtract
right to give me time spent. thanks in advance group

Jeff

 

[Arvi Laanemets]

Hi

With coming time in cell A2 and leaving time in cell B2 (in time format),
and working time interval not including midnight:
=B2-A2

The same when working time includes midnight:
=B2-A2+(B2<A2)