Prev: Can I 'embed' a formula to affect numbers as they're entered?
Next: IF THEN Statement
From: "Bernie Deitrick" deitbe on 11 Feb 2010 11:46
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" <igorin(a)discussions.microsoft.com> wrote in message
news:EBB6A921-7FD4-4E5B-8530-F45A652C9656(a)microsoft.com...
> 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!


First  |  Prev  | 
Pages: 1 2
Prev: Can I 'embed' a formula to affect numbers as they're entered?
Next: IF THEN Statement