Calculate total using hrs by cost per hr

  • Thread starter Thread starter Ron
  • Start date Start date
R

Ron

How to calculate a money sum total using hours multplied by cost per
hour.

B4:B10 has the number of hours worked per day per employee.

B19 has the total hours worked per day for all employees

B20 is the pay per hour.

How do I get a result that shows the product of B19 and B20

TIA

Ron
 
Hi Ron!

If B19 hours is in decimal form

=B19*B20

If B19 is in the form (e.g.) 40:00

=B19*24*B20

In this last for of hours Excel is merely formatting the time elapsed
as 40:00 but is recording it as days. To convert this to hours, I've
multiplied by 24.

--
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.
 
Hi Ron!

Good to see you happy.

For more tips and tricks and explanations of Excel's Date and Time
system see:

Chip Pearson:
http://www.cpearson.com/excel/datetime.htm#AddingTimes

Come back again whenever you have problems.

--
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