Can some one please provide a formula on how to change months into years and
months?
Example, I have 15 months in a cell, but would like the next cell to be read
1.3. meaning 1 year and 3 months.
Thanks
Marty
Can some one please provide a formula on how to change months into years and
months?
Example, I have 15 months in a cell, but would like the next cell to be read
1.3. meaning 1 year and 3 months.
Thanks
Marty
With that format, how are you going to differentiate between 1 year and 1
month and 1 year and 10 months? The numbers 1.1 and 1.10 are indentical to
Excel, so you can't accomplish the visual difference (1.1 vs 1.10) with
formatting.
=DOLLARFR(A1/12,12) will give you 1.01 and 1.10 for the above examples. You
need to format the cell with 2 decimal places so you see 1.10, not just 1.1.
This function is in the Analysis Tool Pack, which must be installed to use the
function.
If you don't want to install the ATP, you can use
=INT(A1/12)+MOD(A1,12)/100
On Thu, 17 Feb 2005 15:15:05 -0800, "Marty" <[email protected]>
wrote:
>Can some one please provide a formula on how to change months into years and
>months?
>Example, I have 15 months in a cell, but would like the next cell to be read
>1.3. meaning 1 year and 3 months.
>Thanks
>
>Marty
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks