At midnight a new day starts. So:

(B1<A1) = TRUE

(B1-A1)+1

It could also be written like:

=B1-A1+(A1B1)

Biff

"Mangus Pyke" wrote in message
...
On Mon, 18 Jul 2005 00:43:30 -0400, "Biff"
wrote:
When time spans past midnight:

A1 = 11:00 PM
B1 = 7:00 AM

=B1-A1+(B1<A1)

Works like a charm. I have no idea why.. but it does.

What exactly is that formula doing, and specifically the part in
parentheses?

MP-

--
"Learning is a behavior that results from consequences."
B.F. Skinner