"Matt" wrote in message
...
I have a cell that works out how many days someone has worked in my company
for. However, I'm trying to change the format of that cell so rather than
it
saying, for example 743 as days, I want it to show as years, months, days
i.e
2:01:15

=DATEDIF(A1,A2,"y")&":"&DATEDIF(A1,A2,"ym")&":"&DA TEDIF(A1,A2,"md")

.... (but for inputs of 0 and 743 it gives 2:0:12, not your 2:01:15).
--
David Biddulph