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.
 
Back
Top