days and time functions

[raogv]

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.

 

[Jacob Skaria]

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]

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

If this post helps click Yes

 

[Jacob Skaria]

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

If this post helps click Yes

 

[raogv]

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

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

If this post helps click Yes

 

[Jacob Skaria]

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

 

[John_Franco]

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.

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