Elapsed time problem....again!

Mike G · May 28, 2007

Please excuse this question one more time, just can't remember how to make
it work. I want the elapsed time for 11 pm to 1 am the next day... TIA

David Biddulph · May 28, 2007

=MOD(B1-A1,1)
or
=(B1-A1)+(B1<A1)

Mike G · May 28, 2007

TX David!

David Biddulph said:
=MOD(B1-A1,1)
or
=(B1-A1)+(B1<A1)