igorin,

You cannot just format the cell to get that. With your value in cell A2

8.3568
Use this in A3 to get full years: =INT(A2)
Use this in A4 to get months (assume that 1 month is 1/12 of a year):
=INT((A2-A3)*12)
Use this in A5 to get days (365 days per year): =INT((A2-A3-A4/12)*365)
Use this in A6: =A2-A3-A4/12-A5/365

Format A6 for HH:MM:SS.

HTH,
Bernie
MS Excel MVP

"igorin" wrote in message
...
Hello,

How can I format the number 8.3568 into:

8 years, 4 months, 8 days, 10 hours, 45 minutes and 7 seconds?

Thank you!