Calculate total using hrs by cost per hr

[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

 

[PTT, Inc.]

=B19*B20

 

[Don Guillett]

If b19 is a number such as 10.5 then just multiply =b19*b20

 

[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
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Ron]

Norman,

B19 is in the hh:mm form and the B19*24*B20 did the trick.

Thank you

Ron

 

[Norman Harker]

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.