Calculate total using hrs by cost per hr

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
 
N

Norman Harker

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
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Top