+ Reply to Thread
Results 1 to 4 of 4

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

  1. #1
    Marc
    Guest

    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. #2
    RagDyer
    Guest

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

    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" <mcnr(N_O-S_P_A_M)@mindspring.com> wrote in message
    news:be9Ke.3107$RZ2.2259@newsread3.news.atl.earthlink.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. #3
    Marc
    Guest

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

    Thanks - Marc


    "RagDyer" <RagDyer@cutoutmsn.com> wrote in message
    news:u2cLbkUnFHA.2860@TK2MSFTNGP15.phx.gbl...
    > 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" <mcnr(N_O-S_P_A_M)@mindspring.com> wrote in message
    > news:be9Ke.3107$RZ2.2259@newsread3.news.atl.earthlink.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. #4
    RagDyer
    Guest

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

    Appreciate the feed-back.
    --
    Regards,

    RD

    ---------------------------------------------------------------------------
    Please keep all correspondence within the NewsGroup, so all may benefit !
    ---------------------------------------------------------------------------

    "Marc" <mcnr(N_O-S_P_A_M)@mindspring.com> wrote in message
    news:kEdKe.3415$Je.1319@newsread2.news.atl.earthlink.net...
    > Thanks - Marc
    >
    >
    > "RagDyer" <RagDyer@cutoutmsn.com> wrote in message
    > news:u2cLbkUnFHA.2860@TK2MSFTNGP15.phx.gbl...
    > > 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" <mcnr(N_O-S_P_A_M)@mindspring.com> wrote in message
    > > news:be9Ke.3107$RZ2.2259@newsread3.news.atl.earthlink.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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1