Thread: Help with date difference
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default 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


Reply With QuoteReply With Quote