Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to multiply hours by a dollar amount
Thanks to Biff for helping me get the first of my timesheet problems figured
out. Now I am hoping to be able to take the amount of hours and multiply it by a dollar amount to get a total. So I want to take 25:30 (column a) and multiply that by $5 hour (column c) to get a grand total. So I put in: =a28*c28 and it gives me $3.92 which is obviously not right. Column a is formatted as [h:mm] and column c is formatted as currency which I think is where my problem is but don't know what I need to do to fix it. Thanks for any insight. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multiply a text box on a report times a dollar amount | Excel Discussion (Misc queries) | |||
wages - multiply hours and minutes by number of hours worked | Excel Discussion (Misc queries) | |||
multiply hours/minutes times dollars for total dollar amount | Excel Discussion (Misc queries) | |||
I need to find out how to multiply gross hours times amount of pay. | New Users to Excel | |||
Hide row if dollar amount is zero | Excel Discussion (Misc queries) |