| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I calculate total pay from pay rate times hours and minutes
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? |
|
#2
|
|||
|
|||
Answer: How do I calculate total pay from pay rate times hours and minutes
__________________
I am not human. I am an Excel Wizard |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I calculate total pay from pay rate times hours and minutes
If A1=Time (hh:mm) and B1=Hourly Rate, then in C1
=A1*24*B1 "Rufus" wrote: 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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I calculate total pay from pay rate times hours and minutes
.... and format C1 as currency
"Rufus" wrote: 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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I calculate total pay from pay rate times hours and min
Please don't post to different NGs to avoid people responding when another
posting has been answered. "Toppers" wrote: ... and format C1 as currency "Rufus" wrote: 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? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I calculate total pay from pay rate times hours and min
I may have posted to different NG with same question the first time because
when I got in here I sent off my question into never-never land and didn't know where it ended up. Haven't used this forum in a long, long time. Anyway, THANKS ! "Toppers" wrote: Please don't post to different NGs to avoid people responding when another posting has been answered. "Toppers" wrote: ... and format C1 as currency "Rufus" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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 | |||
Linear Mode
