Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Instead of using, say, 7.5 for 7 and 1/2 hours, how do I calculate total pay
for 7:30 times, say, an hourly pay rate of $8.25 an hour? Multiplying 7.5 times $8.25 equals $61.87. How do I do the same calculation using 7:30 (i.e. hh:mm) instead of 7.5 for 7 and 1/2 hours? Is there a special format for the result (total pay) cell that will yield the correct answer of $61.87? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculate hours and minutes between times when it goes past midnig | Excel Worksheet Functions | |||
multiply hours/minutes times dollars for total dollar amount | Excel Discussion (Misc queries) | |||
Calculation of hourly rate times hours times 1.5 | Excel Worksheet Functions | |||
How do I calculate total hours by rate of pay? | Excel Worksheet Functions | |||
add hours & minutes to other hours & minutes to receive total hou. | Excel Worksheet Functions |