With your times in A1 and B1
=MOD(B1-A1,1)

--
Regards
Roger Govier
"Chi" wrote in message
...
Hi,
Please show me to fix these problems. Thanks
Ex: 12:30 Am - 11:25 Pm= #VALUE
and
2:50-2:52=# VALUE.


Thank you
Chi