View Single Post
  #4   Report Post  
Bob Phillips
 
Posts: n/a
Default

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)