Time difference

[Prasad_Joshi]

Dear All,

I had a sheet having data of different date & times. I want to calculate the difference between 2 times. Please see attached sheet. I want difference between A3 & A2, A4 & A3.....

Please help me.

Thanks in advance.

Prasad

[Bob Phillips]

A2, A3 etc are not standard date/times.

20 Nov 2006 22:00:16:127

whould be

20 Nov 2006 22:00:16.127

if it is referring to hundredths of a second.

[lilstevie]

If they are hundreths of a second you need to convert your text date / times to excel format dates. Take a look at the attached.

use this Formula to convert to excel date format:
CONCATENATE(LEFT(A2,20),".",RIGHT(A2,3))+0

and this cell Custom format to display them as you want:
dd mmm yyyy hh:mm:ss.000