calculating date

[shivam0101]

I have 2 columns with dates in the following format,

dd-mm-yyyy hh:mm:ss:sss

A2 = 10-10-2009 10:06:06:100
B2 = 10-10-2009 10:06:06:101

I want B2-A2 in C2

I tried using =B2-A2 in C2 column. I am not getting the expected value.

Expected value,

00-00-0000 00:00:00:001

Thanks

[martindwilson]

surely the format should be
dd/mm/yyyy hh:mm:ss.000
then subtracting one from the other will give
00/01/1900 00:00:00.001

[DonkeyOte]

If your values are as you say they are, and assuming you can not alter them, you can use:

C2: =SUBSTITUTE(B2,":",".",3)-SUBSTITUTE(A2,":",".",3)

I would suggest formatting C2 as: [hh]:mm:ss.000