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

"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.

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