I'd like to make a custom number format that would split apart a decimal number and take everything to the left and follow that with a Y or Years and take everything to the right, multiply it by 12, and follow that with a M or Months.
TLDR Example:
4.01 would be 4 Y 0 M,
3.27 would be 3 Y 3 M,
2.92 would be 2 Y 11 M,
1.99 needs to be 2 Y 0 M,
0.45 would be 0 Y 5 M
It doesn't matter if the month carries the decimal value along (it'd be better that way), so long as the value displayed does not contain a value.
If this can't be done in one cell, then that's fine and I wouldn't mind suggestions using multiple cells, but the goal is to tidy this process up so that I can put a formula in a cell that pulls other cell references, so having a single cell with a single custom format would be awesome.
I found two answers coming from two different directions on this here, the only issue is that the first answer would need me to separate my decimal and do the math on the latter half and then concatenate the two together (which would work). I'd go that route if it were necessary, but I was hoping for a way to just use the decimal as is and convert the back half by multiplying it by 12 in the custom format. The second answer was a problem, because I need the cell to be referenced by another cell with it showing as a decimal value to that other cell.
