I need to find out how to multiply gross hours times amount of pay.

  • Thread starter Thread starter Marc
  • Start date Start date
M

Marc

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
 
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!
==============================================
 
Thanks - Marc


RagDyer said:
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!
==============================================


rate
Click to expand...
 
Back
Top