View Full Version : Time difference

12-11-2006, 02:42 AM
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.


Bob Phillips
12-11-2006, 04:09 AM
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.

12-11-2006, 08:33 AM
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:

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