trt this formatted as hh:mm

=B1-A1 + (B1<A1)

Mike

"doss04" wrote:

I'm very new at excel. trying to self learn. I've read many post regarding
times. I not sure if i'm seeing the answers i'm looking for. I do security
patrols. I am looking for a way to calculate how long a patrol takes. I'm
explain what i'm looking for.
First: is there a way to just click on a cell and have the now time appear.
Then click on a 2nd cell, and have the now time appear without changing the
1st time. Then have the total automaticly add.

A B C
Arrive Clear Total
22:35 22:55 20min
23:45 00:55 1:10

It needs to be able to add past midnight.

If anyone can help i would really appreciate it.