Time multiplied by cost per hr

S

Steve Tupper

I want to get XL to give me the result of the following type of calculations:

41hr 55mins (entered into a cell as 41:55:00 ?) multiplied by the rate per
hr entered in another cell as a monetary amount of say 563.50 to give the
resultant cost in a 3rd cell.

I want to be able to enter time as hrs & minutes NOT as hrs and a decimal of
an hr.
 
R

Roger Govier

Hi Steve

Excel stores times a fractions of a day, so multiply your result by 24.

with time in A1, rate in B1
=A1*B1*24
 

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

Work Budget Salary vs Real Time Salary 0
Multiplying the number in one cell and providing the product in an 4
Multiplying hrs worked by cost per hr 3
Calculate per minute cost of cell phone usage 1
Group Time 3
Calculate Total hours worked during workdays within given shift time. 2
overtime calculation 1
Time by cost 1

Top