Assuming A1 is formatted as HH:MM then in C1:

=A1*24*B1*2 (to convert the time to decimal portion of a day - 24 hours
=1.000, 12hrs 26 mins =0.5180555556)


=£175.06 (I believe!)


HTH
"Monty" wrote:

i would like to have in cell A1 the number of overtime hrs worked per week
for one member of staff which in this case is 12hrs 26mins. in cell b1 i
have the hourly rate £7.04, in cell c1 i have the following=A1*B1*2 this
should bring back £175.02 however it brings back £172.62. it would appear
that it is not picking up the mins.
does anyone have any suggestions.

Thanks

Monty