I'm trying to find out the difference between two times, for example,

In at 20:55 (8:55 PM)
Out at 21:10 (9:10 PM)

I know that if I substract 21:10 from 20:55 I'll get 0:15 minutes.

But my problem is this

In at 23:50 (11:50 PM)
Out at 0:10 (12:10 AM)

I get ###### as my answer, does anybody know how to do this operation??

Use this formula:

=b1-a1+(b1<a1)

Regards,
Fred.

"GEM" wrote in message
...
I'm trying to find out the difference between two times, for example,

In at 20:55 (8:55 PM)
Out at 21:10 (9:10 PM)

I know that if I substract 21:10 from 20:55 I'll get 0:15 minutes.

But my problem is this

In at 23:50 (11:50 PM)
Out at 0:10 (12:10 AM)

I get ###### as my answer, does anybody know how to do this operation??

You can do it like this:

=B1-A1+(B1<A1)

where A1 is the start time and B1 is the finish time. This takes
account of time wrapping around midnight.

Hope this helps.

Pete

On Oct 1, 12:56*am, GEM wrote:
I'm trying to find out the difference between two times, for example,

In at 20:55 (8:55 PM)
Out at 21:10 (9:10 PM)

I know that if I substract 21:10 from 20:55 I'll get 0:15 minutes.

But my problem is this

In at 23:50 (11:50 PM)
Out at 0:10 (12:10 AM)

I get ###### as my answer, does anybody know how to do this operation??

=MOD(B1-A1,1)


"GEM" wrote:

I'm trying to find out the difference between two times, for example,

In at 20:55 (8:55 PM)
Out at 21:10 (9:10 PM)

I know that if I substract 21:10 from 20:55 I'll get 0:15 minutes.

But my problem is this

In at 23:50 (11:50 PM)
Out at 0:10 (12:10 AM)

I get ###### as my answer, does anybody know how to do this operation??

Thanks to all!!!!!!

"GEM" wrote:

I'm trying to find out the difference between two times, for example,

In at 20:55 (8:55 PM)
Out at 21:10 (9:10 PM)

I know that if I substract 21:10 from 20:55 I'll get 0:15 minutes.

But my problem is this

In at 23:50 (11:50 PM)
Out at 0:10 (12:10 AM)

I get ###### as my answer, does anybody know how to do this operation??