YY,

You could try and just use

=A3-A2

or, to be clearer in your formula,

=VALUE(A3)-VALUE(A2)

HTH,
Bernie
MS Excel MVP


"YY san." wrote in message
...
Hi,
I need some help on date. I have the date and time in text format.
13/01/2010 10:34 AM
13/01/2010 1:56 PM

I need a formula to convert them to excel date/time format so that I can
do
subtraction between these dates.

Thank you very much,
YY