My best guess at what you want: =B1-A1+(B1<A1) Biff
J JE McGimpsey Mar 2, 2006 #2 one way: A1: 20:00 B1: 03:45 C1: =MOD(B1-A1,1) Format C1 as time. "peter" <[email protected]> wrote: