hourly rates
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
|