Formula Help - Time Difference in Days, Hours Mins & Seconds
 

I would like to calculate Time Difference in Days, Hours Mins & Seconds.

My Dates are 1/24/06 12:10:14 AM & 1/27/06 2:10:14 PM . I need a help with the excel formula

Formula Help - Time Difference in Days, Hours Mins & Seconds
 

If your start time/date is in A1 and end time/date in B1 you can simpl
use

=B1-A1

and format as

d \d\a\y\s hh:mm:ss

to show in format like

4 days 12:34:56

this is limited to time periods up to 32 days (because days sets bac
to zero after 31

--
daddylongleg
-----------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...fo&userid=3048
View this thread: http://www.excelforum.com/showthread.php?threadid=50509

Formula Help - Time Difference in Days, Hours Mins & Seconds
 

A1: Start Date/time
A2: End Date/Time

=A2-A1
format the cell as dd hh:mm:ss

as long as your difference doesn't exceed 30 days, this should work.

--
Regards,
Tom Ogilvy


"Shashi Bhosale" wrote in message
...
I would like to calculate Time Difference in Days, Hours Mins & Seconds.

My Dates are 1/24/06 12:10:14 AM & 1/27/06 2:10:14 PM . I need a help with
the excel formula