how to multiply hour to currency/hour

  • Thread starter Thread starter Rasoul Khoshravan Azar
  • Start date Start date
R

Rasoul Khoshravan Azar

I want to multiply 45: 15 hours to 600 Dollors/hour to obtain 27,150 $
First cell has 45:15 hours in time format and second cell has 600$ with
currency format but multiplication cell shows 1,131.25$ which is not
correct. I tried to change the cell format but it didn't help. How can I
solve this simple issue.

TIA Rasoul Khoshravan Azar
 
Hi
format the time with 24 and format the resulting cell as number
 
I'm not actually sure why at this point, but if you multiply the result by
24, this should give you the desired answer.

--
Michael J. Malinsky
Pittsburgh, PA

"I am a bear of very little brain, and long
words bother me." -- AA Milne, Winnie the Pooh
 
Your Date - Your Date - Your Date<g>

Please don't multipost. See ans in your other post
 
I know > I know > I know
Don't know how it happened. Atomic clock fixed now.
 
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

velocity=Distance/time 2
Basic hours * rate formula 1
Subtracting 37 hours from a cell containing format [h]:mm 2
Currency & hours 1
Calculating hours elapsed when date/ time > 24 hours 1
Adding six hours to a time 2
Multiplying time by $ per hour 10
Formating Cells to Calculate Hours of Work 4

Back
Top