Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
How do I change months into years?
I'm doing a homework assignment that is about analyzing employee information.
The previous job experience in listed in month, but I need to convert the months into years. I have no idea how I go about doing that. I'm thinking I may have to nest some functions together but I'm not sure. If anybody could help me with this, it would be great! Thank you! |
#2
|
|||
|
|||
This might get you started http://www.cpearson.com/excel/datetime.htm
-- HTH RP (remove nothere from the email address if mailing direct) "Kara" wrote in message ... I'm doing a homework assignment that is about analyzing employee information. The previous job experience in listed in month, but I need to convert the months into years. I have no idea how I go about doing that. I'm thinking I may have to nest some functions together but I'm not sure. If anybody could help me with this, it would be great! Thank you! |
#3
|
|||
|
|||
Assuming the previous job experience is listed in months in Column A,
starting in cell A2, then put this in cell B2 and copy down......... =A1/12 Vaya con Dios, Chuck, CABGx3 "Kara" wrote in message ... I'm doing a homework assignment that is about analyzing employee information. The previous job experience in listed in month, but I need to convert the months into years. I have no idea how I go about doing that. I'm thinking I may have to nest some functions together but I'm not sure. If anybody could help me with this, it would be great! Thank you! |
#4
|
|||
|
|||
If you mean you have data like 63 months, how about dividing by 12?
On Sun, 17 Apr 2005 15:13:01 -0700, "Kara" wrote: I'm doing a homework assignment that is about analyzing employee information. The previous job experience in listed in month, but I need to convert the months into years. I have no idea how I go about doing that. I'm thinking I may have to nest some functions together but I'm not sure. If anybody could help me with this, it would be great! Thank you! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculate date differences in years and months | Excel Worksheet Functions | |||
How do i change 15 months to read 1 year and 3 months? | Excel Discussion (Misc queries) | |||
Converting months to years | Excel Worksheet Functions | |||
years and months | Excel Worksheet Functions | |||
How do I display months and years between two dates | Excel Discussion (Misc queries) |