how do i track time

  • Thread starter Thread starter Jeff
  • Start date Start date
J

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
 
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)
 
Back
Top