Hi,

Am Tue, 2 Oct 2012 09:36:29 -0700 (PDT) schrieb :

093004000
093005000

Which is hh:mm:ss.millisec

I would like to convert the data so that when I add or subtract the 2 values I get the actual time difference in hh:mm:ss.

In the example above, if I did (093005000
- 093005000) the result would be 00:00:01.

try:
=(A2-A1)/86400000
and format the cell hh:mm:ss


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2