multiplycation of money cell and time cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How to multiply a cell that has a dollar value to a cell that consists of a
time difference. Example: cell A1 is $5.00, cell B1 is 10:00 AM and cell B2
is 10:00 PM and cell B3 is 12:00 which is the difference of cell B2 and B1.
Now the problem is the multiplying cell A1 to B3. The value does not match
for some reason. I don't know how to make it work. If anyone does, please
help. Thank you. Anderson
 
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

separating date and time 5
Excel In Excel how can I block the contenent of a cell? 0
Can I use the NOW() function in a formula? 2
Adding hours to a time 2
Comparison of columns using Conditional Formatting 3
formula for changing a percentage 1
how to get "day/night" from a cell of time/hour 3
Extracting just the time portion 5

Back
Top