software

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?

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

=DATEDIF(A1,A2,quot;yquot;)amp;quot;:quot;amp;DATEDIF(A1,A2,quot;ymquot;)amp;quot;:quot;amp;DA TEDIF(A1,A2,quot;mdquot;)

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

www.cpearson.com/excel/datedif.htm

--
Kind regards,

Niek Otten

quot;Mattquot; gt; 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?