Excel Formula to Convert expense time units in Excel!!

So far we have learned the formulas to convert Celsius to Fahrenheit in Excel Office 365. Likewise, here we are going to ** convert expense time units in Excel*. Let’s get them below!! Get an official version of * MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

Generic Formula

• Use the below-mentioned formula to convert expense time units in Excel.

=$C5*[INDEX](https://geekexcel.com/index-function-in-microsoft-excel-365-how-to-use/)(data,[MATCH](https://geekexcel.com/how-to-use-match-function-in-microsoft-excel-365/)($D5,vunits,0),[MATCH](https://geekexcel.com/how-to-use-match-function-in-microsoft-excel-365/)(F$4,hunits,0))

Syntax Explanation

• *MATCH * – The *MATCH function in Excel * is used to locate the position of a lookup value in a row, column, or table.
• INDEX ** – The **INDEX function returns the value at a given position in a range or array. INDEX is frequently used together with the MATCH function.
• Parenthesis () – The purpose of this symbol is to group the elements.
• **Comma symbol (,) – **It is a separator that helps to separate a list of values.

Practical Examples

Refer to the below example image.

• For instance, you have to create a sample data in Excel.

Sample data

• To convert expense time units, you need to use the following formula in formula bar.

=$C5*[INDEX](https://geekexcel.com/index-function-in-microsoft-excel-365-how-to-use/)(data,[MATCH](https://geekexcel.com/how-to-use-match-function-in-microsoft-excel-365/)($D5,vunits,0),[MATCH](https://geekexcel.com/how-to-use-match-function-in-microsoft-excel-365/)(F$4,hunits,0))

Use the Formula

• Then, you have to Hit the Enter key to get the result in the cell F5 as shown below.

Result for the cell F5

• Now, you need to press Ctrl+D key to get the results in all other columns.

Output

Wind-Up

So yeah guys this is how you can ** convert expense time units in Excel*. Hope you like this article. If you have any **questions* , feel free to comment. Thank you so much for visiting Geek Excel!! *If you want to learn more helpful formulas, check out Excel Formulas *!!

Read Ahead:

• How to Convert Between Various Measurement Units in Excel Office 365?
• How to Use “CONVERT function” in Microsoft Excel 365? [With Examples]
• Excel Formulas to Split the Numbers from Units of Measure ~ Easily!!
• How to Convert Text String to Formula in Excel Office 365?
• Excel Formulas to Extract the Time from Date and Time ~ Quick Method!!