Product of Hrs & minutes times rate per hr to give a cost

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

I have formatted a cell in hr:mm:ss and have a number in another cell and
have inserted a formula in a third cell to multiply cells 1 and 2 together
but I am not getting the correct answer. Presumably I need to format one or
all of these cells differently.

Please help!!!
 
If your hr:mm:ss really is a number formatted as a time, then you probably
just need to multiply your result by 24 and format the result as currency.
The reason for multiplying by 24 that 1 represents a day, so an hour is 1/24,
but you need to get the number of hours.
 
You must log in or register to reply here.

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

Time multiplied by cost per hr 2
Multiplying hrs worked by cost per hr 3
WKLY HRS/WKLY PAY = Rate per HR 2
Multiplying the number in one cell and providing the product in an 4
Is it possible to split 1 cell into 3 cells w/o affecting other ce 1
Excel Excel calculate pay based on rate per minute 7
Time x Rate 2
Time by cost 1

Back
Top