excel-formulaexcel-2013
Multiplying different number formats in Excel
I'm using an excel document to track my hours at work (this is my 3rd question about it)
I'm trying to figure out how to multiply a time (i.e. 62:05, which is how long I have worked for over 2 weeks), by my hourly rate (11$/hr) and get approximate gross earnings in this format: $667.43
my time format is [hh]:mm and the 11/hr format doesn't do anything other than the total being 29.0000382 something.
Solution
Consider this formula:
=A1*24*B1
- How can I convert text in a cell to a sequence of ascii code values with a separator in Excel 2016 or LibreOffice?
- Excel Chart title will not accept a date concatonated to a string
- Power Query Filtered Rows based on value
- Unable to use a dynamic named range as a data series - what am I doing wrong?
- List Sheet Names Without Macro or Excel 4 Functions
- Excel - Aggregate dynamically values in a Table using array formulas (MAP, BYROW, CHOOSECOLS, TEXTJOIN, LAMBDA, FILTER, HSTACK) in a single Cell
- VBA CountIf() loop / Countifs() loop
- excel filter data and remove units of measurement
- Excel Count if first character is 0 in string
- Excel: How to take a weighted average where blank values cause proportional weighting shifts
- How do I conditionally append a row of Excel data from one sheet to another?
- Efficient formula or code to determine number of errors in range VBA
- Extract separated date from a text
- Rank numbers including NA()s in Excel 365
- Is it possible to dynamically change a cell/column reference in an excell formula based on another cell
- Excel - create a list from a data column but ignore/remove blank cells
- Split text string in Excel by semicolons and space
- Formula in Excel to count occurrences of substrings within strings
- find closed match value in matrix and return its row and column header in excel
- Excel - Return value based in two conditions
- excel group column highlight matching values
- Excel - Display entry with the highest value that meets a case-sensitive condition
- Excel Formula changes values after a day or so
- How to sum multiple columns with multiple conditions
- MATCH formula with multiple conditions returning true when false
- Finding the closest date in Excel
- How to sort text values the same way as a web-based staircase generator
- Is there a way to find first non zero value for a lookup value in excel
- Spill formula on % calculation
- Excel: preserve hyperlink to the cell in the current sheet after copying the sheet