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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
or even =A1*24*50 :-)



"RagDyeR" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
or even =A1*24*50 :-)



"RagDyeR" wrote in message
...
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" wrote in message
...
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" wrote in message
...
Two keys between on mine, so I have no excuse if I do it <ebg

Bob


"RagDyeR" wrote in message
...
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" wrote in message
...
or even =A1*24*50 :-)



"RagDyeR" wrote in message
...
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" wrote in message
...
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" wrote in message
...
I give up!

What does <ebg mean?
--

Regards,

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

"Bob Phillips" wrote in message
...
Two keys between on mine, so I have no excuse if I do it <ebg

Bob


"RagDyeR" wrote in message
...
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" wrote in message
...
or even =A1*24*50 :-)



"RagDyeR" wrote in message
...
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" wrote in message
...
I would like to convert hours into money using an excel formula (ie
1.00
hour
at £50 per hour)