Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I multiply rate per hour by hours worked.
I have set up a worksheet where you enter start time and finish time and
total hours worked for the week but then I want to multiply the result by rate per hour but when I do I get the result in time format not currency. Any Suggestions. |
#2
|
|||
|
|||
Hi
try =A10*24*wage and format as number -- Regards Frank Kabel Frankfurt, Germany MAC wrote: I have set up a worksheet where you enter start time and finish time and total hours worked for the week but then I want to multiply the result by rate per hour but when I do I get the result in time format not currency. Any Suggestions. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CALCULATE HOURS WORKED | Excel Discussion (Misc queries) | |||
excel template that can add up hours and cost per hour | Excel Discussion (Misc queries) | |||
Subtracting paid hours from unpaid hours | Excel Worksheet Functions | |||
Hours worked | Excel Worksheet Functions | |||
calculate average hours worked | Excel Worksheet Functions |