Calculate Time Period -

Time Period.xlsx

Hello

I need to measure time taken for a task where the time goes over into the next day.

The Basic formula I have will only cover same day tasks as the Time Out is higher than Time In.

Times are in 24 hour.

Try this in E6 and drag it down:

=IF(D6<C6,(D6+1)-C6,D6-C6)