months brokendown by 12 months
 

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

months brokendown by 12 months
 

Do you mean

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

If this post helps click Yes
---------------
Jacob Skaria


"Hank" wrote:

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

months brokendown by 12 months
 

I need numeric 12, 12, 12, 12 3

Thanks Jacob!

Hank

"Jacob Skaria" wrote:

Do you mean

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

If this post helps click Yes
---------------
Jacob Skaria


"Hank" wrote:

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

months brokendown by 12 months
 

'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
---------------
Jacob Skaria


"Hank" wrote:

I need numeric 12, 12, 12, 12 3

Thanks Jacob!

Hank

"Jacob Skaria" wrote:

Do you mean

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

If this post helps click Yes
---------------
Jacob Skaria


"Hank" wrote:

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