| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Convert Hours to Cash
I would like to convert hours into money using an excel formula (ie 1.00 hour
at £50 per hour) |
|
#2
|
|||
|
|||
|
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) |
|
#3
|
|||
|
|||
|
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) |
|
#4
|
|||
|
|||
|
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) |
|
#5
|
|||
|
|||
|
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) |
|
#6
|
|||
|
|||
|
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) |
|
#7
|
|||
|
|||
|
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) |
|
#8
|
|||
|
|||
|
<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) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to convert hours in days? | Excel Worksheet Functions | |||
| How can I convert fractional hours to minutes? | Excel Discussion (Misc queries) | |||
| convert hours and minutes to minutes | Excel Discussion (Misc queries) | |||
| How do I convert times from hours to minutes? | Excel Discussion (Misc queries) | |||
| how to convert total hours (HH:MM) into decimal number | Excel Worksheet Functions | |||
Linear Mode
