Formula -Multiplication Function

  • Thread starter Thread starter sandra.coleman3
  • Start date Start date
S

sandra.coleman3

Can you multiply TIME format with Currency format? New to
show and automate hours and dollars in payroll sheet.
Thanks!
 
Hi Sandra

If time is shown in A1 in Excel format 6:00 for 6 elapsed hours:
If currency amount is in B1

C1:
=(A1*24)*B1
Format currency

Time is stored by Excel as a decimal of 1 day so we need to convert to
hours before multiplying by the currency.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

TIME X MONEY 1
IF formula for currency or Macro help. 0
CONCATENATE & LOOKUP Functions 0
I need calculated time in a "real number" format 2
Calculating payroll cost 1
How to multiply hours by a dollar amount 3
Multiply Cell Values which include text units 6
Converting from Norwegian Krone to US Dollars format 7

Back
Top