=MOD(B1-A1,1)

--
HTH

Bob Phillips

<a wrote in message ...
I have two times,
22:19 pm and 1:50 am
obviously 1:50 is after 22:19 but when I try to subtract it -- 22:19 -
1:50
excel gives me gibberish.

thnks.