Formula to calulate wages
Hi Mike
Works great. However the calculation does not work if hours are 24 or more.
Any suggestions
Stuart
"Mike H" wrote:
Hi,
Maybe this
=(HOUR(A1)+MINUTE(A1)/60)*A2
Format as general
Mike
"Stuart WJG" wrote:
I have a hours in A1 (formatted [hh]:mm) and a rate in £ in A2. In A3 I have
A1*A2 to give total of wages. I have tried formatting in [hh]:mm and number
but cannot get it to work
any suggestions
|