Help with date difference

T

Tom

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
 
D

David Biddulph

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Check if a date comes before/after a range of dates 0
How to count non blank cells with a condition? 1
SUMIF Formula Help 8
Reverse Index Match 2
Calculate the difference in date/time formatted cells 4
Filtering by newest date 2
separating date and time 5
Find then highlight in yellow 6

Top