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

Any ideas?

"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

See

http://www.cpearson.com/excel/datedif.htm

--
Kind regards,

Niek Otten

"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
|
| Any ideas?