Convert Hours to Cash

[Guest]

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

 

[RagDyeR]

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

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

 

[RagDyeR]

Typo - Try:

=A1*24*50
--

Regards,

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

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

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

 

[Bob Phillips]

or even =A1*24*50

 

[RagDyeR]

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

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

 

[Bob Phillips]

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

Bob

 

[RagDyeR]

I give up!

What does <ebg> mean?

 

[Bob Phillips]

<even bigger grin>

Bob

I give up!

What does <ebg> mean?
--

Regards,

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

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

Bob