months brokendown by 12 months

  • Thread starter Thread starter Hank
  • Start date Start date
H

Hank

Hello, I need some help to breakdown a total months to months in a year, such
as

total 32 months will be broken down by 12month 12month and 8month
total 63 months will be broken down by 12month 12 month 12 month 12 month
12 month and 3 month.

Is there any function in excel can do that??

Thanks a lot
Hank
 
Do you mean

A1 = 63
In B1
=REPT("12month ",INT(A1/12)) & "and " & MOD(A1,12) & "months"

If this post helps click Yes
 
'If you mean only the numerics in a cell then try the below

=REPT("12, ",INT(A1/12)) & MOD(A1,12)

'If you are looking to have the numerics in separate cells try the below
=IF(COLUMN(A1)<=INT($A1/12),12,IF(COLUMN(A1)=INT($A1/12)+1,MOD($A1,12),""))
and copy to the right as required

If this post helps click Yes
 
Back
Top