ExcelBanter - Help with date difference

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Help with date difference (https://www.excelbanter.com/excel-discussion-misc-queries/232654-help-date-difference.html)

Tom

Help with date difference

Cells A1 and B1 contains two different dates, 1/01/2008 and 8/04/2009. How
do you show the date difference in C1 which has the format yy:mm:dd as
01:03:07

TIA
Tom

David Biddulph[_2_]

Help with date difference

=TEXT(DATEDIF(A1,B1,"y"),"00")&":"&TEXT(DATEDIF(A1 ,B1,"ym"),"00")&":"&TEXT(DATEDIF(A1,B1,"md"),"00")
--
David Biddulph

Tom wrote:
Cells A1 and B1 contains two different dates, 1/01/2008 and
8/04/2009. How do you show the date difference in C1 which has the
format yy:mm:dd as 01:03:07

TIA
Tom

Tom

Help with date difference

That's neat. Thanks David.

Tom

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
=TEXT(DATEDIF(A1,B1,"y"),"00")&":"&TEXT(DATEDIF(A1 ,B1,"ym"),"00")&":"&TEXT(DATEDIF(A1,B1,"md"),"00")
--
David Biddulph

Tom wrote:
Cells A1 and B1 contains two different dates, 1/01/2008 and
8/04/2009. How do you show the date difference in C1 which has the
format yy:mm:dd as 01:03:07

TIA
Tom

All times are GMT +1. The time now is 12:11 AM.