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?