multiplycation of money cell and time cell
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 |
Hi!
=(B3*24)*A1 Biff "engr625" wrote in message ... 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 |
All times are GMT +1. The time now is 07:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com