If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Can i get a formula to change hours into currency £
I am looking for a formula to change working hours i.e (78h 30m ) into
currency i.e £6.00 £6.00 x 78:30 ( h:mm ) = £471.00 Excel 2007 |
#2
|
|||
|
|||
Can i get a formula to change hours into currency £
"David Wilson" wrote:
I am looking for a formula to change working hours i.e (78h 30m ) into currency i.e £6.00 £6.00 x 78:30 ( h:mm ) = £471.00 Well, you almost have it. If A1 contains 6.00, the hourly rate, and A2 contains 78:30, the hours worked, the total pay is: =round(A1*A2*24,2) formatted as Number with 2 decimal places. Note that A1 should also be formatted as Number with 2 decimal places, and A2 should have the Custom format "[h]:mm" without the quotes. The ROUND function is necessary because the format only affects the appearance of the value, not the underlying value. It does not matter with your example. |
#3
|
|||
|
|||
Can i get a formula to change hours into currency £
hi
with 78:30:00 in A2..... =(A2*24)*6 format as currency. regards FSt1 "David Wilson" wrote: I am looking for a formula to change working hours i.e (78h 30m ) into currency i.e £6.00 £6.00 x 78:30 ( h:mm ) = £471.00 Excel 2007 |
Thread Tools | |
Display Modes | |
|
|