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

If your start time/date is in A1 and end time/date in B1 you can simply 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 back to zero after 31)

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" <skb@kingsbury.com> wrote in message
news:O9pqzBfIGHA.3000@TK2MSFTNGP14.phx.gbl...
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