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
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!
==============================================
"Marc" <mcnr(N_O-S_P_A_M)@mindspring.com> wrote in message
news:[email protected]...
> 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
>
>
>
Thanks - Marc
"RagDyer" <[email protected]> wrote in message
news:[email protected]...
> 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:[email protected]...
> > 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
> >
> >
> >
>
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:[email protected]...
> Thanks - Marc
>
>
> "RagDyer" <[email protected]> wrote in message
> news:[email protected]...
> > 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:[email protected]...
> > > 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
> > >
> > >
> > >
> >
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks