| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
I need to find out how to multiply gross hours times amount of pay.
I have the cells formatted for time and summed and I know that this actually
represents a number in Excel but how do I multiply that number times rate of pay? Marc |
|
#2
|
|||
|
|||
|
Format the next column over to "Number" or "General",
Then multiply your total time by 24 to get decimal hours. Then you can use that same cell and multiply by pay rate, or you can do that in the next column if you wish. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Marc" wrote in message ink.net... I have the cells formatted for time and summed and I know that this actually represents a number in Excel but how do I multiply that number times rate of pay? Marc |
|
#3
|
|||
|
|||
|
Thanks - Marc
"RagDyer" wrote in message ... Format the next column over to "Number" or "General", Then multiply your total time by 24 to get decimal hours. Then you can use that same cell and multiply by pay rate, or you can do that in the next column if you wish. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Marc" wrote in message ink.net... I have the cells formatted for time and summed and I know that this actually represents a number in Excel but how do I multiply that number times rate of pay? Marc |
|
#4
|
|||
|
|||
|
Appreciate the feed-back.
-- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Marc" wrote in message nk.net... Thanks - Marc "RagDyer" wrote in message ... Format the next column over to "Number" or "General", Then multiply your total time by 24 to get decimal hours. Then you can use that same cell and multiply by pay rate, or you can do that in the next column if you wish. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Marc" wrote in message ink.net... I have the cells formatted for time and summed and I know that this actually represents a number in Excel but how do I multiply that number times rate of pay? Marc |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I find the amount of hours between times? | Excel Discussion (Misc queries) | |||
| How can I make a timesheet to figure my hours and payrate? | Excel Worksheet Functions | |||
| calculate hours just can't figure it out | Excel Worksheet Functions | |||
| How do I multiply rate per hour by hours worked. | Excel Worksheet Functions | |||
| Subtracting paid hours from unpaid hours | Excel Worksheet Functions | |||
Hybrid Mode
