David Wilson said:
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.
