Thanks for reply.
Don't result.

The original format cell is General.
After change to Time format or h:mm:ss AM/PM don't result too.

Thanks you.
an

"Bernard Liengme" wrote:

VALUE(B1)-A1
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"an" wrote in message
...
Hi!

I have a time table with:

A B
1 11:55:00 AM 2:20:00 PM

If aplied the formulae =(B1-A1) return #VALUE error, because there are one
space before first digit.

If erased the space, work fine.
With Find and Replace don't solve the problem.

Is possible to solve this problem automaticly, please?
Thanks in advance.
an