Difference between two dates

[Karthick.icwa]

Hi experts,

I am trying to calculate the dufference between two given dates,

my date format is as follows,

A1 = 12-mar-2012 12:05:30 PM
B1 = 17-Jun-2012 02:06:35 AM

Now i want to calculate month , days , hours between these two days (i.e like 2 months 27 days 8 hrs 1 min)

how do i achive this?

I have been tried with Custom number format dd:hh:mm (days,hours,mins), but it gives only days upto 31 days.

Please help,

Karthick

[npamcpp]

If you calculate =B2-A2 then format the cell with a custom format, for example

m "months", d "days" hh:mm:ss

which, with your sample data will return: 3 months, 6 days 03:26:31

[Karthick.icwa]

Hi,
Thanks for your valuable input.i tried the same but the result what I am getting not accurate.can u explain further

[harish bajaj]

=DATEDIF(A1,B1,"y")&" YEAR "&DATEDIF(A1,B1,"ym")&" MONTHS "&DATEDIF(A1,B1,"md")
&" DAYS"


Try this Formula : Start Date:A1, End Date : B1. You will get duration between TWO dates in Year,Months and Days.

[marc5354]

Hi Karthick,

Please find attached sample workbook.

Hope this will sort out your problem.

Marc

[Cutter]

This is marc5354's file from post #5 (which uses harish bajaj's suggestion from post #4) with npamcpp's suggestion from post #2 in cell D2.

[Karthick.icwa]

Hi experts,

Thanks again, Your solution works fine.

But i also need to track the Hours & Minutes.Is there any formula which will accomodate this requirement?

Please suggest.

Thanks in advance,

Karthick

[Karthick.icwa]

Hi,

Your suggestion really helpful,

But what about if the the difference exceeding a year. How to bring the year value?

Thanks,

Karthick