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

Multiplying hrs worked by cost per hr 3
Calculate Total hours worked during workdays within given shift time. 2
WKLY HRS/WKLY PAY = Rate per HR 2
overtime calculation 1
How to enter start and end date/time in excel based on some specific value. 7
Group Time 3
Time to dollars 4
Entering times in 24 hour format 12

Top