With start date in A1 and end date time in A2, try the below

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

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