Thanks to every one. The problem was the formula
Using =(IF(A2B2,B2+1-A2,B2-A2)) does the trick with the format [hh]:mm

"PA" wrote:

I remember reading this on this or another Excel group, and now can not find
it. Please help

Column A and B contain Start and End time.
Column C calculates elapsed time =B2-A2
=B3-A3
etc
The sum total elapsed time at bottom of Column C
What I can not remember is the custom format to use in column C so that if
the end time goes past midnight, it calculates correctly.
Thanks for repeating the answer for me.

Paul