days and time functions
 

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

days and time functions
 

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

days and time functions
 

=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

days and time functions
 

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

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


"Jacob Skaria" wrote:

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

days and time functions
 

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

days and time functions
 

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

Just subtract, use -

Forget the date format, Excel dates are sequential numbers

Your result will be 2.32638888889051

What does this mean?

You have 2 days and 0.32638888889051 time

Assign a 37:30:55 time format to 0.32638888889051 and convert this decimal date code to 7:50:00

You have 2 days and 7:50:00 hours

Done

Your result will be 2.326388889

What does this mean?

You have 2 days and 0.326388889 time

Convert 0.326388889 to time format 37:30:55 for example and done

Learn more about excel dates, visit: http://www.excel-spreadsheet-authors...xcel-date.html