Please note that the TEXT() function will convert the format to text whereas
the below will not.....

A2-A1 and custom format the cell to dd:hh:mm:ss


If this post helps click Yes
---------------
Jacob Skaria


"raogv" wrote:

my problem is solved. Thanks a lot sir.
--
gv


"Jacob Skaria" wrote:

=TEXT(A2-A1,"dd:hh:mm:ss")

If this post helps click Yes
---------------
Jacob Skaria


"raogv" wrote:

Dear
I requesting all who read this. start time 01 May 09 09:20:00 to 03 May
09 17:10:00 , reqired farmula for difference bewteen the time , answer
required in the formate - days:hrs:mins:sec .

Thanks regards.
--
gv