calculate difference between two dates and times in "days, hrs, mins, secs"

**mankit87** · 10-24-2011, 04:49 AM

Let say I have two cell with date and time together.

Start date and time- A1: "01 Feb 2001 03:35:33"
End date and time-B1:"05May 2001 04:28:21"

What should I do to calculate the difference between with the result "days","hrs","mins" and "secs"?

**zbor** · 10-24-2011, 04:56 AM

If those are dates write: =A2-A1 and format cell as: d" days "h" hrs "m" mins "s" secs"

**daddylonglegs** · 10-24-2011, 07:49 AM

Fomatting using "d" for days doesn't work for periods over 31 days (because "d" shows day of month rather than elapsed days), so that format won't work for the example given beacuse days will show as 2 rather than 93

Assuming A1 and B1 are valid date/times then try this formula in C1

=INT(B1-A1)&" days "&TEXT(B1-A1,"h"" hrs ""m"" mins ""s""secs""")

**zbor** · 10-24-2011, 07:58 AM

Thank for improvement and explanation

**mankit87** · 10-24-2011, 09:15 AM

wau!! million of thank to daddylonglegs. Not forget zbor too! thank for helping.

**meatychi** · 09-03-2013, 03:20 AM

Hi,

Could you help me with the formula which displays the output in just hours and minutes?

**Debraj Roy** · 09-03-2013, 03:31 AM

Hi meatychi

Welcome to the forum..
Please read Forum Rules,
Although its appreciable that you have picked approx similar topic to post.. but hijacking other post is against forum's rule..
Please start a New Thread.. and you may got better response..

**ha suong** · 09-03-2013, 03:34 AM

Please help to count days
Start date End Date Total
8/16/2013 8/31/2013 15

But as you can see, the date I count by myself is 16 days, not 15 as the result.
Pls help urgently.

Many thanks

**Debraj Roy** · 09-03-2013, 03:44 AM

Please read Forum Rules,
Although its appreciable that you have picked approx similar topic to post.. but hijacking other post is against forum's rule..
Please start a New Thread.. and you may got better response..

**zbor** · 09-03-2013, 04:27 AM

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.