Can i get a formula to change hours into currency £

[David Wilson]

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

 

[JoeU2004]

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.

 

[JoeU2004]

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.

 

[FSt1]

hi
with 78:30:00 in A2.....
=(A2*24)*6
format as currency.

regards
FSt1

 

[FSt1]

hi
with 78:30:00 in A2.....
=(A2*24)*6
format as currency.

regards
FSt1