how to multiply hour to currency/hour

  • Thread starter Rasoul Khoshravan Azar
  • 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
 
M

Michael Malinsky

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
 
R

RagDyeR

Your Date - Your Date - Your Date<g>

Please don't multipost. See ans in your other post
 

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
Multiply hours:minutes by cost/hour to get total cost? 4
How to count hours- and multiply with my wage per hour... 4
changing clock time to 12 hour format 1
Multiply Cell Values which include text units 6
How do I multiply rate per hour by hours worked. 1
add/sub time/hour tracking in 24 clock format 1
How to multiply number of hours by number? 6

Top