Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
conversion question
is there a formula to convert 5.08 into years/months? I know 5 = 5 years,
but can't figure out how to determine what .08 is. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
conversion question
Maybe
=INT(A1)&" Years "&ROUND(MOD(A1,1)*12,2)&" Months" where A1 = 5.08 which is 0.96. If you have specific start/end dates, you may want to look at DateDif. Whether or not 0.08 of a year is one month depends on which month you're talking about. "Tammi P" wrote: is there a formula to convert 5.08 into years/months? I know 5 = 5 years, but can't figure out how to determine what .08 is. Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
conversion question
Hi, Assuming your data is in A1 and that 0.08 is a decimal representation B1 = DATE(2000+FLOOR(A1,1),1,MOD(A1,1)*365) You could use the data at this point by custom formatting it, or you could add two more cells with =MONTH(B1) =YEAR(B1) and custom format them. Either way, it will work. -- KellTainer ------------------------------------------------------------------------ KellTainer's Profile: http://www.excelforum.com/member.php...o&userid=34322 View this thread: http://www.excelforum.com/showthread...hreadid=544500 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
conversion question
Thank you! I will see if there are specific start/end dates - although I'm
not sure how to use the DateDif - so I may post again. "JMB" wrote: Maybe =INT(A1)&" Years "&ROUND(MOD(A1,1)*12,2)&" Months" where A1 = 5.08 which is 0.96. If you have specific start/end dates, you may want to look at DateDif. Whether or not 0.08 of a year is one month depends on which month you're talking about. "Tammi P" wrote: is there a formula to convert 5.08 into years/months? I know 5 = 5 years, but can't figure out how to determine what .08 is. Thanks |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
conversion question
You're welcome.
"Tammi P" wrote: Thank you! I will see if there are specific start/end dates - although I'm not sure how to use the DateDif - so I may post again. "JMB" wrote: Maybe =INT(A1)&" Years "&ROUND(MOD(A1,1)*12,2)&" Months" where A1 = 5.08 which is 0.96. If you have specific start/end dates, you may want to look at DateDif. Whether or not 0.08 of a year is one month depends on which month you're talking about. "Tammi P" wrote: is there a formula to convert 5.08 into years/months? I know 5 = 5 years, but can't figure out how to determine what .08 is. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Question on this conversion code switching between r1c1 to A1 format tia sal2 | Excel Worksheet Functions | |||
Question on this conversion code switching between r1c1 to A1 format tia sal2 | Excel Discussion (Misc queries) | |||
Another Time Conversion question | Excel Discussion (Misc queries) | |||
Time Conversion question | Excel Discussion (Misc queries) | |||
date conversion question | Excel Programming |