Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating months with half months. | Excel Discussion (Misc queries) | |||
3 months prior and 3 months post a date | Excel Worksheet Functions | |||
Adding months to dates should account for 28-30-31 day months | Excel Worksheet Functions | |||
converting months to years and months??? | Excel Discussion (Misc queries) | |||
How do i change 15 months to read 1 year and 3 months? | Excel Discussion (Misc queries) |