This decimal is a fraction of the day. For the detailed steps, please see How to change date format in Excel. How to convert from decimal coordinate (1,1) to Excel Style Coordinate A1 in Select a blank cell which you want to output the converted result, and enter this formula =A2/24, drag fill handle over the cells you need. If you want to convert date in Cell A13 to text, but in mmddyyyy format, type this formula =TEXT(A13,"mmddyyyy") press Enter key. For example, Excel users can easily combine worksheets with several clicks, merge cells without losing data, paste to only visible cells, and so on. DAYS: Returns the number of days between two dates. DAYS360: Returns days between 2 dates in a 360 day year. EOMONTH I selected the cell E4 After that, type the formula either in the selected cell or in the Formula Bar. TIME MID. This can be done by wrapping each formula into an IF statement. DAYS360: Returns days between 2 dates in a 360 day year. DAYS: Returns the number of days between two dates. Asked 11 years, 2 months ago. Solved by adding a column to the Excel Table with the formula: =A1*1 (date in cell A1) which filled down automatically (love Tables) then copy and pasted as values on top of the errant dates. DAYS360: Returns days between 2 dates in a 360 day year. In the TEXT function, you can use different codes for months and years, such as: "mmm" - abbreviated months names, as Jan - Dec. Fractions: After you apply a fraction format to a cell, decimal numbers as well as actual fractions that you type in that cell will be displayed as a fraction. VBA: Convert decimal time to hours and minutes. The program operates on data entered in cells of a table. See screenshot: 2. To sum it up, 1002 days also means 2 years, 9 months, and 2 days. One minute in Excel is represented by the number: 1/(24*60) = 1/1440 = 0.000694 Number of days, months or years between two dates. Convert text to date. Excel Mobile is a spreadsheet program that can edit XLSX files. The numbers that you will be converting into percentages can be given to you in two different formats: decimal and fraction. So the formula will be: =A2*365 DAYS360: Returns days between 2 dates in a 360 day year. See screenshot: 2. and now you need to add a number of days, years, months, hours, minutes, or seconds to this date. MOD. The result of the above formulas is a serial number representing the date. Asked 11 years, 2 months ago. EDATE: Returns a date, n months away from a start date. These dates are still stored as serial numbers in Excel. Decimal time is the representation of the time of day using units which are decimally related. 1. Note. You can leverage Excel's AutoFill feature to enter a series of numbers faster. One hour in Excel is represented by the number: 1/24 = 0.04167. Example 2. Convert decimal hours/minutes to time format with formulas. Excel Macro to Copy and Paste Format Line by Line instead of range of cells. The question asked was how to format a value to display in Lakh decimal, which isn't the question you answered. You also can use the YEARFRAC function to count the months in Excel. DATE LEFT MID RIGHT. Excel Drop Down List: It is used to allow the user to select the month name. Excel Drop Down List: It is used to allow the user to select the month name. What went into making this Excel Timesheet Calculator template. EDATE: Returns a date, n months away from a start date. DATEDIF LET. DATEVALUE: Converts a date stored as text into a valid date: DAY: Returns the day as a number (1-31). One hour in Excel is represented by the number: 1/24 = 0.04167. Thanks for responding, and I hope this helps. Convert text to date. Hi Did anyone know how to convert a decimal number to years,months & days. To convert a given date to year and month, you can use the TEXT function to extract each unit individually, and then concatenate those functions within one formula. EDATE: Returns a date, n months away from a start date. Number of days, months or years between two dates. Convert Unix time stamp to Excel date. The result of the above formulas is a serial number representing the date. To get it displayed as a date, select the cell(s) and press Ctrl+1 to open the Format Cells dialog. DATEVALUE: Converts a date stored as text into a valid date: DAY: Returns the day as a number (1-31). For example, typing .5 or 1/2 For that, you need to select a cell first, to put your resultant value. To convert .87 to a percent, simply multiply .87 by 100. The result of the above formulas is a serial number representing the date. When the YEARFRAC function returns, for example, 10.3 years and relays it to the INT function, it will convert it to 10 years. See screenshot: 2. Each cell may contain either numeric or text data, or the results of formulas that automatically calculate and display a When you convert the date with a time to the number format, you will see a decimal number. EOMONTH DATEVALUE: Converts a date stored as text into a valid date: DAY: Returns the day as a number (1-31). Spreadsheets were developed as computerized analogs of paper accounting worksheets. Welcome to Videojug! Select a blank cell which you want to output the converted result, and enter this formula =A2/24, drag fill handle over the cells you need. DAYS360: Returns days between 2 dates in a 360 day year. Number of days, months or years between two dates. Select the fraction numbers you will convert, right click and select Format Cells from the context menu. To sum it up, 1002 days also means 2 years, 9 months, and 2 days. 2. 1. Learn how to use Excel's LINEST function for both Mac and PC. 1. There is a more straight forward method to import data from text/csv into Excel (2017): Open a blank book in Excel and click in import data from text/csv. Hi Did anyone know how to convert a decimal number to years,months & days. Made an Excel Table, then a Pivot Table, but could not Group. Number of days, months or years between two dates. DAYS360: Returns days between 2 dates in a 360 day year. 1. Excel Formulas: A number of Excel functions such as DATE, MATCH, INT, IF, and IFERROR is used to calculate the values (such as the date from selection or regular/overtime hours) in this timesheet template. On the Number tab, select Date in the Category list, and then choose the date format you want. DATEVALUE: Converts a date stored as text into a valid date: DAY: Returns the day as a number (1-31). DATEVALUE: Converts a date stored as text into a valid date: DAY: Returns the day as a number (1-31). The INT function has a sole purpose removing values after the decimal. will display a decimal in its equivalent % format and round according to the number of decimal places entered. Let's start with why we have the INT function in the formula. Here are some simple formulas which can help you to quickly convert decimal hours or decimal minutes to hh:mm:ss. Viewed 219k times into an Excel column (e.g. What went into making this Excel Timesheet Calculator template. TIME MID. In fact, in comments, the poster specifically noted he or she was not looking to simply convert. Decimal format is easier to calculate into a percentage. Solved by adding a column to the Excel Table with the formula: =A1*1 (date in cell A1) which filled down automatically (love Tables) then copy and pasted as values on top of the errant dates. Decimal format is easier to calculate into a percentage. Number of days, months or years between two dates. DAYS: Returns the number of days between two dates. Please follow below steps to convert fraction numbers to normal decimal numbers in Excel. Now lets take a look at how to do the reverse how to convert the number of days back to years. For example, typing .5 or 1/2 Convert text to date. Use IF statements in amortization formulas. 1.2 Convert date to text in mmddyyyy or ddmmyyyy format. Dimension to Date Transformation: Convert the Column Type; computeExpression Transformation; Data Type Conversion Transformations: Convert Column Types; Run Data Sync and Recipes to Create and Refresh Datasets; update Parameters; Data Sync Limits and Considerations; Pull Data Directly into Recipes; String Functions for Unconverted Formulas Convert text timestamp into time. Excel Drop Down List: It is used to allow the user to select the month name. EDATE: Returns a date, n months away from a start date. Moving on, let's see what the YEAFRAC function does. See screenshot: 2. For the detailed steps, please see How to change date format in Excel. Converting Years to Days in Excel. The entire list was in text imported from another program. DATEVALUE: Converts a date stored as text into a valid date: DAY: Returns the day as a number (1-31). Converting a decimal to a percentage is as simple as multiplying it by 100. A spreadsheet is a computer application for computation, organization, analysis and storage of data in tabular form. When the YEARFRAC function returns, for example, 10.3 years and relays it to the INT function, it will convert it to 10 years. DAYS: Returns the number of days between two dates. Excel Macro to Copy and Paste Format Line by Line instead of range of cells. Converting a decimal to a percentage is as simple as multiplying it by 100. Because you now have many excessive period numbers, you have to somehow limit the calculations to the actual number of payments for a particular loan. I selected the cell E4 After that, type the formula either in the selected cell or in the Formula Bar. VBA: Convert decimal time to hours and minutes. EDATE: Returns a date, n months away from a start date. So 24.5% has been rounded to 1 decimal place. Copy and paste this code into your website. and now you need to add a number of days, years, months, hours, minutes, or seconds to this date. Asked 11 years, 2 months ago. For the detailed steps, please see How to change date format in Excel. For ex 1.50=1years 6months , llly how to convert 1.56 , or any other decimal into y,m & days. Leverage our proprietary and industry-renowned methodology to develop and refine your strategy, strengthen your teams, and win new business. EDATE: Returns a date, n months away from a start date. In Excel 2010, the strength of the protection by the default was increased two times due to the use of a 100,000-fold SHA1 to convert a password to a key. Hi Did anyone know how to convert a decimal number to years,months & days. EOMONTH EOMONTH In fact, in comments, the poster specifically noted he or she was not looking to simply convert. AA) 0. Each cell may contain either numeric or text data, or the results of formulas that automatically calculate and display a Convert time to money. Get days, months, and years between dates. This term is often used specifically to refer to the time system used in France for a few years beginning in 1792 during the French Revolution, which divided the day into 10 decimal hours, each decimal hour into 100 decimal minutes and each decimal minute into 100 decimal seconds EOMONTH DATEVALUE: Converts a date stored as text into a valid date: DAY: Returns the day as a number (1-31). DAYS360: Returns days between 2 dates in a 360 day year. Let's start with why we have the INT function in the formula. So the formula will be: =A2*365 On the Number tab, select Date in the Category list, and then choose the date format you want. Convert text timestamp into time. Number of days, months or years between two dates. Learn how to use Excel's LINEST function for both Mac and PC. The assistant will show a preview of the data, but if you are importing from a csv with decimal / scientific numbers all will be recognized as text. Click Insert > Module, and copy the VBA into the module. DAYS360: Returns days between 2 dates in a 360 day year. Excel Formulas: A number of Excel functions such as DATE, MATCH, INT, IF, and IFERROR is used to calculate the values (such as the date from selection or regular/overtime hours) in this timesheet template. Decimal time is the representation of the time of day using units which are decimally related. One hour in Excel is represented by the number: 1/24 = 0.04167. DAYS: Returns the number of days between two dates. I tried the below formula but its not working (Cell A1=1.5) INT(A1) for years INT(MOD(A1,365)/30) for months ROUND(MOD((MOD(A1,365)),30),0) for days Do i need to enable any add ins or options To sum it up, 1002 days also means 2 years, 9 months, and 2 days. DAYS: Returns the number of days between two dates. Convert decimal hours/minutes to time format with formulas. EOMONTH EOMONTH Convert time to time zone. Decimal time is the representation of the time of day using units which are decimally related. To get it displayed as a date, select the cell(s) and press Ctrl+1 to open the Format Cells dialog. EDATE: Returns a date, n months away from a start date. Number of days, months or years between two dates. DAYS: Returns the number of days between two dates. To count months using YEARFRAC you need to multiply the result by 12 to convert it into months. Here you'll find the best how-to videos around, from delicious, easy-to-follow recipes to beauty and fashion tips. Get earliest and latest project dates. There is a more straight forward method to import data from text/csv into Excel (2017): Open a blank book in Excel and click in import data from text/csv. Includes numerous formula examples in Excel and VBA (WITH PICTURES). If you want to convert date in Cell A18 to text in ddmmyyyy format, type this formula =TEXT(A18,"ddmmyyyy") press Enter key. Copy and paste this code into your website. Convert Unix time stamp to Excel date. Decimal format is easier to calculate into a percentage. In the TEXT function, you can use different codes for months and years, such as: "mmm" - abbreviated months names, as Jan - Dec. EDATE: Returns a date, n months away from a start date. To get it displayed as a date, select the cell(s) and press Ctrl+1 to open the Format Cells dialog. Convert date to month and year in Excel. Now lets take a look at how to do the reverse how to convert the number of days back to years. Here you'll find the best how-to videos around, from delicious, easy-to-follow recipes to beauty and fashion tips. Made an Excel Table, then a Pivot Table, but could not Group. AA) 0. If you want to convert date in Cell A18 to text in ddmmyyyy format, type this formula =TEXT(A18,"ddmmyyyy") press Enter key. 1.2 Convert date to text in mmddyyyy or ddmmyyyy format. When you convert the date with a time to the number format, you will see a decimal number. Leverage our proprietary and industry-renowned methodology to develop and refine your strategy, strengthen your teams, and win new business. Convert time to money. Number of days, months or years between two dates. Moving on, let's see what the YEAFRAC function does. The program operates on data entered in cells of a table. Select the fraction numbers you will convert, right click and select Format Cells from the context menu. Let's start with why we have the INT function in the formula. Get days, months, and years between dates. Other platforms Excel for mobile. will display a decimal in its equivalent % format and round according to the number of decimal places entered. When you convert the date with a time to the number format, you will see a decimal number. Get days, months, and years between dates. Number of days, months or years between two dates. This can be done by wrapping each formula into an IF statement. Spreadsheets were developed as computerized analogs of paper accounting worksheets. To convert a given date to year and month, you can use the TEXT function to extract each unit individually, and then concatenate those functions within one formula. This decimal is a fraction of the day. DAYS360: Returns days between 2 dates in a 360 day year. Select a blank cell which you want to output the converted result, and enter this formula =A2/24, drag fill handle over the cells you need. DATEVALUE: Converts a date stored as text into a valid date: DAY: Returns the day as a number (1-31). Number of days, months or years between two dates. Thanks for responding, and I hope this helps. The question asked was how to format a value to display in Lakh decimal, which isn't the question you answered. 2. Modified 3 years, 1 month ago. So the formula will be: =A2*365 will display a decimal in its equivalent % format and round according to the number of decimal places entered. EOMONTH Solved by adding a column to the Excel Table with the formula: =A1*1 (date in cell A1) which filled down automatically (love Tables) then copy and pasted as values on top of the errant dates. You also can use the YEARFRAC function to count the months in Excel. Convert time to time zone. Select the file. DAYS360: Returns days between 2 dates in a 360 day year. Each cell may contain either numeric or text data, or the results of formulas that automatically calculate and display a This decimal is a fraction of the day. Note. How to convert from decimal coordinate (1,1) to Excel Style Coordinate A1 in Number of days, months or years between two dates. DAYS: Returns the number of days between two dates. EDATE: Returns a date, n months away from a start date. Convert decimal hours/minutes to time format with formulas. Welcome to Videojug! Number of days, months or years between two dates. AA) 0. Excel Mobile is a spreadsheet program that can edit XLSX files. Convert Excel time to decimal seconds. EDATE: Returns a date, n months away from a start date. DATEVALUE: Converts a date stored as text into a valid date: DAY: Returns the day as a number (1-31). The question asked was how to format a value to display in Lakh decimal, which isn't the question you answered. The entire list was in text imported from another program. This term is often used specifically to refer to the time system used in France for a few years beginning in 1792 during the French Revolution, which divided the day into 10 decimal hours, each decimal hour into 100 decimal minutes and each decimal minute into 100 decimal seconds So 24.5% has been rounded to 1 decimal place. 1. DATE LEFT MID RIGHT. Other platforms Excel for mobile. Spreadsheets were developed as computerized analogs of paper accounting worksheets. Select the file. Dimension to Date Transformation: Convert the Column Type; computeExpression Transformation; Data Type Conversion Transformations: Convert Column Types; Run Data Sync and Recipes to Create and Refresh Datasets; update Parameters; Data Sync Limits and Considerations; Pull Data Directly into Recipes; String Functions for Unconverted Formulas MOD. To count months using YEARFRAC you need to multiply the result by 12 to convert it into months. Made an Excel Table, then a Pivot Table, but could not Group. DATEVALUE: Converts a date stored as text into a valid date: DAY: Returns the day as a number (1-31). Excel Macro to Copy and Paste Format Line by Line instead of range of cells. Convert decimal to hours, minutes and seconds with formul. Here are some simple formulas which can help you to quickly convert decimal hours or decimal minutes to hh:mm:ss. Convert Excel time to decimal seconds. 2. Learn how to use Excel's LINEST function for both Mac and PC. If you want to convert date in Cell A18 to text in ddmmyyyy format, type this formula =TEXT(A18,"ddmmyyyy") press Enter key. When the YEARFRAC function returns, for example, 10.3 years and relays it to the INT function, it will convert it to 10 years. EOMONTH For ex 1.50=1years 6months , llly how to convert 1.56 , or any other decimal into y,m & days. Jaden - Editor's Pick 2019-11-19 20:10:12 I love this site you people are doing great keep it up.It helps me pull up my grades in now i get better grades.In long,lat is great for people that don't know how to use this site.I rlly hope you ppl keep up the great work.The more you do a good job the more i show people about this site.I rly use this site every day.Because is helps you To convert .87 to a percent, simply multiply .87 by 100. This term is often used specifically to refer to the time system used in France for a few years beginning in 1792 during the French Revolution, which divided the day into 10 decimal hours, each decimal hour into 100 decimal minutes and each decimal minute into 100 decimal seconds Use IF statements in amortization formulas. Kutools for Excel is a handy Excel add-in with more than 300 advanced features to simplify various kinds of complicated tasks into a few clicks in Excel. These dates are still stored as serial numbers in Excel. One minute in Excel is represented by the number: 1/(24*60) = 1/1440 = 0.000694 Jaden - Editor's Pick 2019-11-19 20:10:12 I love this site you people are doing great keep it up.It helps me pull up my grades in now i get better grades.In long,lat is great for people that don't know how to use this site.I rlly hope you ppl keep up the great work.The more you do a good job the more i show people about this site.I rly use this site every day.Because is helps you Kutools for Excel is a handy Excel add-in with more than 300 advanced features to simplify various kinds of complicated tasks into a few clicks in Excel. and now you need to add a number of days, years, months, hours, minutes, or seconds to this date. To count months using YEARFRAC you need to multiply the result by 12 to convert it into months. DAYS360: Returns days between 2 dates in a 360 day year. EOMONTH For that, you need to select a cell first, to put your resultant value. Get earliest and latest project dates. Note. Convert date to month and year in Excel. How to convert from decimal coordinate (1,1) to Excel Style Coordinate A1 in DAYS360: Returns days between 2 dates in a 360 day year. Jaden - Editor's Pick 2019-11-19 20:10:12 I love this site you people are doing great keep it up.It helps me pull up my grades in now i get better grades.In long,lat is great for people that don't know how to use this site.I rlly hope you ppl keep up the great work.The more you do a good job the more i show people about this site.I rly use this site every day.Because is helps you Viewed 219k times into an Excel column (e.g. If you want to convert date in Cell A13 to text, but in mmddyyyy format, type this formula =TEXT(A13,"mmddyyyy") press Enter key. Number of days, months or years between two dates. The program operates on data entered in cells of a table. One minute in Excel is represented by the number: 1/(24*60) = 1/1440 = 0.000694 1. 1. Excel Formulas: A number of Excel functions such as DATE, MATCH, INT, IF, and IFERROR is used to calculate the values (such as the date from selection or regular/overtime hours) in this timesheet template. Dimension to Date Transformation: Convert the Column Type; computeExpression Transformation; Data Type Conversion Transformations: Convert Column Types; Run Data Sync and Recipes to Create and Refresh Datasets; update Parameters; Data Sync Limits and Considerations; Pull Data Directly into Recipes; String Functions for Unconverted Formulas Number of days, months or years between two dates. Fractions: After you apply a fraction format to a cell, decimal numbers as well as actual fractions that you type in that cell will be displayed as a fraction. Converting a decimal to a percentage is as simple as multiplying it by 100. Example 2. EOMONTH This can be done by wrapping each formula into an IF statement. If you want to convert date in Cell A13 to text, but in mmddyyyy format, type this formula =TEXT(A13,"mmddyyyy") press Enter key. Convert time to money. DAYS: Returns the number of days between two dates. Number of days, months or years between two dates. What went into making this Excel Timesheet Calculator template. See screenshot: 2. Because you now have many excessive period numbers, you have to somehow limit the calculations to the actual number of payments for a particular loan. Copy and paste this code into your website. The numbers that you will be converting into percentages can be given to you in two different formats: decimal and fraction. EOMONTH The entire list was in text imported from another program. You can leverage Excel's AutoFill feature to enter a series of numbers faster. Thanks for responding, and I hope this helps. DATEDIF LET. Convert date to month and year in Excel. DAYS360: Returns days between 2 dates in a 360 day year. Here are some simple formulas which can help you to quickly convert decimal hours or decimal minutes to hh:mm:ss. 1. Moving on, let's see what the YEAFRAC function does. Use IF statements in amortization formulas. Convert text timestamp into time. These dates are still stored as serial numbers in Excel. For ex 1.50=1years 6months , llly how to convert 1.56 , or any other decimal into y,m & days. Convert decimal to hours, minutes and seconds with formul. Click Insert > Module, and copy the VBA into the module. To convert .87 to a percent, simply multiply .87 by 100. See screenshot: 2. Get earliest and latest project dates. MOD. DAYS: Returns the number of days between two dates. EOMONTH Number of days, months or years between two dates. EDATE: Returns a date, n months away from a start date. The INT function has a sole purpose removing values after the decimal. DATEVALUE: Converts a date stored as text into a valid date: DAY: Returns the day as a number (1-31). I tried the below formula but its not working (Cell A1=1.5) INT(A1) for years INT(MOD(A1,365)/30) for months ROUND(MOD((MOD(A1,365)),30),0) for days Do i need to enable any add ins or options Welcome to Videojug! You also can use the YEARFRAC function to count the months in Excel. There is a more straight forward method to import data from text/csv into Excel (2017): Open a blank book in Excel and click in import data from text/csv. In Excel 2010, the strength of the protection by the default was increased two times due to the use of a 100,000-fold SHA1 to convert a password to a key. Convert Unix time stamp to Excel date. Convert decimal to hours, minutes and seconds with formul. TIME MID. EOMONTH Leverage our proprietary and industry-renowned methodology to develop and refine your strategy, strengthen your teams, and win new business. For example, Excel users can easily combine worksheets with several clicks, merge cells without losing data, paste to only visible cells, and so on. Includes numerous formula examples in Excel and VBA (WITH PICTURES). DAYS360: Returns days between 2 dates in a 360 day year. DAYS: Returns the number of days between two dates. Click Insert > Module, and copy the VBA into the module. DAYS: Returns the number of days between two dates. Converting Years to Days in Excel. To convert a given date to year and month, you can use the TEXT function to extract each unit individually, and then concatenate those functions within one formula. DATEVALUE: Converts a date stored as text into a valid date: DAY: Returns the day as a number (1-31). You can leverage Excel's AutoFill feature to enter a series of numbers faster. EDATE: Returns a date, n months away from a start date. EDATE: Returns a date, n months away from a start date. In the TEXT function, you can use different codes for months and years, such as: "mmm" - abbreviated months names, as Jan - Dec. EDATE: Returns a date, n months away from a start date. For example, Excel users can easily combine worksheets with several clicks, merge cells without losing data, paste to only visible cells, and so on. Excel Mobile is a spreadsheet program that can edit XLSX files. Number of days, months or years between two dates. The assistant will show a preview of the data, but if you are importing from a csv with decimal / scientific numbers all will be recognized as text. The INT function has a sole purpose removing values after the decimal. The numbers that you will be converting into percentages can be given to you in two different formats: decimal and fraction. 1. On the Number tab, select Date in the Category list, and then choose the date format you want. DATE LEFT MID RIGHT. Please follow below steps to convert fraction numbers to normal decimal numbers in Excel. This is really very simple since we again need to use the same concept of 1 year = 365 days. The assistant will show a preview of the data, but if you are importing from a csv with decimal / scientific numbers all will be recognized as text. Here you'll find the best how-to videos around, from delicious, easy-to-follow recipes to beauty and fashion tips. Convert Excel time to decimal seconds. For that, you need to select a cell first, to put your resultant value. Kutools for Excel is a handy Excel add-in with more than 300 advanced features to simplify various kinds of complicated tasks into a few clicks in Excel. DATEVALUE: Converts a date stored as text into a valid date: DAY: Returns the day as a number (1-31). A spreadsheet is a computer application for computation, organization, analysis and storage of data in tabular form. Because you now have many excessive period numbers, you have to somehow limit the calculations to the actual number of payments for a particular loan. This is really very simple since we again need to use the same concept of 1 year = 365 days. Select the fraction numbers you will convert, right click and select Format Cells from the context menu. In Excel 2010, the strength of the protection by the default was increased two times due to the use of a 100,000-fold SHA1 to convert a password to a key. This is really very simple since we again need to use the same concept of 1 year = 365 days. DATEVALUE: Converts a date stored as text into a valid date: DAY: Returns the day as a number (1-31).
What Is Deprivation Of Liberty, How To Make A 3d Football Out Of Cardboard, When Will Canterbury Park Open, Who Said Gadzooks, How To Make A Wall In Little Alchemy 2, How To 're Grip Taylormade Bubble Shaft, How To Grow Inferium Seeds Sky Factory 4, How To Change Sensitivity On Minecraft Java 2020, How Much Does The Office Cast Make On Reruns,
how to convert years and months into decimal in excel