Convert Hours to Cash

I would like to convert hours into money using an excel formula (ie 1.00 hour
at £50 per hour)

With hours in A1, expressed as hh:mm, in B1 try

=A1*24-50

With B1 formatted as a number or General.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Maureen" <Maureen@discussions.microsoft.com> wrote in message
news:4C975BB1-31F3-4E02-8C53-BD546AC93328@microsoft.com...
I would like to convert hours into money using an excel formula (ie 1.00
hour
at £50 per hour)

Typo - Try:

=A1*24*50
--

Regards,

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

"RagDyeR" <ragdyer@cutoutmsn.com> wrote in message
news:OYXnJMpQFHA.1236@TK2MSFTNGP14.phx.gbl...
With hours in A1, expressed as hh:mm, in B1 try

=A1*24-50

With B1 formatted as a number or General.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Maureen" <Maureen@discussions.microsoft.com> wrote in message
news:4C975BB1-31F3-4E02-8C53-BD546AC93328@microsoft.com...
I would like to convert hours into money using an excel formula (ie 1.00
hour
at £50 per hour)

or even =A1*24*50 :-)



"RagDyeR" <ragdyer@cutoutmsn.com> wrote in message
news:OYXnJMpQFHA.1236@TK2MSFTNGP14.phx.gbl...
> With hours in A1, expressed as hh:mm, in B1 try
>
> =A1*24-50
>
> With B1 formatted as a number or General.
> --
>
> HTH,
>
> RD
> ==============================================
> Please keep all correspondence within the Group, so all may benefit!
> ==============================================
>
> "Maureen" <Maureen@discussions.microsoft.com> wrote in message
> news:4C975BB1-31F3-4E02-8C53-BD546AC93328@microsoft.com...
> I would like to convert hours into money using an excel formula (ie 1.00
> hour
> at £50 per hour)
>
>

Well, the 2 keys are right next to each other.<g>

(On MY keyboard, that is.)<vbg>
--

Regards,

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



"Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message
news:eRNw1UpQFHA.1392@TK2MSFTNGP10.phx.gbl...
or even =A1*24*50 :-)



"RagDyeR" <ragdyer@cutoutmsn.com> wrote in message
news:OYXnJMpQFHA.1236@TK2MSFTNGP14.phx.gbl...
> With hours in A1, expressed as hh:mm, in B1 try
>
> =A1*24-50
>
> With B1 formatted as a number or General.
> --
>
> HTH,
>
> RD
> ==============================================
> Please keep all correspondence within the Group, so all may benefit!
> ==============================================
>
> "Maureen" <Maureen@discussions.microsoft.com> wrote in message
> news:4C975BB1-31F3-4E02-8C53-BD546AC93328@microsoft.com...
> I would like to convert hours into money using an excel formula (ie 1.00
> hour
> at £50 per hour)
>
>

Two keys between on mine, so I have no excuse if I do it <ebg>

Bob


"RagDyeR" <ragdyer@cutoutmsn.com> wrote in message
news:%23C23btpQFHA.3076@tk2msftngp13.phx.gbl...
> Well, the 2 keys are right next to each other.<g>
>
> (On MY keyboard, that is.)<vbg>
> --
>
> Regards,
>
> RD
> --------------------------------------------------------------------
> Please keep all correspondence within the Group, so all may benefit !
> --------------------------------------------------------------------
>
>
>
> "Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message
> news:eRNw1UpQFHA.1392@TK2MSFTNGP10.phx.gbl...
> or even =A1*24*50 :-)
>
>
>
> "RagDyeR" <ragdyer@cutoutmsn.com> wrote in message
> news:OYXnJMpQFHA.1236@TK2MSFTNGP14.phx.gbl...
> > With hours in A1, expressed as hh:mm, in B1 try
> >
> > =A1*24-50
> >
> > With B1 formatted as a number or General.
> > --
> >
> > HTH,
> >
> > RD
> > ==============================================
> > Please keep all correspondence within the Group, so all may benefit!
> > ==============================================
> >
> > "Maureen" <Maureen@discussions.microsoft.com> wrote in message
> > news:4C975BB1-31F3-4E02-8C53-BD546AC93328@microsoft.com...
> > I would like to convert hours into money using an excel formula (ie 1.00
> > hour
> > at £50 per hour)
> >
> >
>
>
>

I give up!

What does <ebg> mean?
--

Regards,

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

"Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message
news:uMmc$gqQFHA.2972@TK2MSFTNGP14.phx.gbl...
Two keys between on mine, so I have no excuse if I do it <ebg>

Bob


"RagDyeR" <ragdyer@cutoutmsn.com> wrote in message
news:%23C23btpQFHA.3076@tk2msftngp13.phx.gbl...
> Well, the 2 keys are right next to each other.<g>
>
> (On MY keyboard, that is.)<vbg>
> --
>
> Regards,
>
> RD
> --------------------------------------------------------------------
> Please keep all correspondence within the Group, so all may benefit !
> --------------------------------------------------------------------
>
>
>
> "Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message
> news:eRNw1UpQFHA.1392@TK2MSFTNGP10.phx.gbl...
> or even =A1*24*50 :-)
>
>
>
> "RagDyeR" <ragdyer@cutoutmsn.com> wrote in message
> news:OYXnJMpQFHA.1236@TK2MSFTNGP14.phx.gbl...
> > With hours in A1, expressed as hh:mm, in B1 try
> >
> > =A1*24-50
> >
> > With B1 formatted as a number or General.
> > --
> >
> > HTH,
> >
> > RD
> > ==============================================
> > Please keep all correspondence within the Group, so all may benefit!
> > ==============================================
> >
> > "Maureen" <Maureen@discussions.microsoft.com> wrote in message
> > news:4C975BB1-31F3-4E02-8C53-BD546AC93328@microsoft.com...
> > I would like to convert hours into money using an excel formula (ie 1.00
> > hour
> > at £50 per hour)
> >
> >
>
>
>

<even bigger grin>

Bob

"RagDyeR" <ragdyer@cutoutmsn.com> wrote in message
news:eFLgnErQFHA.2972@TK2MSFTNGP14.phx.gbl...
> I give up!
>
> What does <ebg> mean?
> --
>
> Regards,
>
> RD
> --------------------------------------------------------------------
> Please keep all correspondence within the Group, so all may benefit !
> --------------------------------------------------------------------
>
> "Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message
> news:uMmc$gqQFHA.2972@TK2MSFTNGP14.phx.gbl...
> Two keys between on mine, so I have no excuse if I do it <ebg>
>
> Bob
>
>
> "RagDyeR" <ragdyer@cutoutmsn.com> wrote in message
> news:%23C23btpQFHA.3076@tk2msftngp13.phx.gbl...
> > Well, the 2 keys are right next to each other.<g>
> >
> > (On MY keyboard, that is.)<vbg>
> > --
> >
> > Regards,
> >
> > RD
> > --------------------------------------------------------------------
> > Please keep all correspondence within the Group, so all may benefit !
> > --------------------------------------------------------------------
> >
> >
> >
> > "Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message
> > news:eRNw1UpQFHA.1392@TK2MSFTNGP10.phx.gbl...
> > or even =A1*24*50 :-)
> >
> >
> >
> > "RagDyeR" <ragdyer@cutoutmsn.com> wrote in message
> > news:OYXnJMpQFHA.1236@TK2MSFTNGP14.phx.gbl...
> > > With hours in A1, expressed as hh:mm, in B1 try
> > >
> > > =A1*24-50
> > >
> > > With B1 formatted as a number or General.
> > > --
> > >
> > > HTH,
> > >
> > > RD
> > > ==============================================
> > > Please keep all correspondence within the Group, so all may benefit!
> > > ==============================================
> > >
> > > "Maureen" <Maureen@discussions.microsoft.com> wrote in message
> > > news:4C975BB1-31F3-4E02-8C53-BD546AC93328@microsoft.com...
> > > I would like to convert hours into money using an excel formula (ie
1.00
> > > hour
> > > at £50 per hour)
> > >
> > >
> >
> >
> >
>
>
>