One way:

A1: <hours
A2: <rate

A3: =(A1+MAX(A1-8,0)/2)*A2


BTW - ALL CAPS in these groups is generally considered the equivalent
of shouting, and should be avoided. It's also harder to read...

In article ,
"garpavco" wrote:

TRYING TO CALCULATE 8 HRS STRAIGHT TIME, IN ADDITION TO ANY HOURS OVER 8
MULTIPLY BY 1 1/2 IN THE SAME CELL