WHAT'S THE FORMULA FOR CALCULATING OVERTIME IN 1 CELL? EXAMPLE: 8.
 

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

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

One way, assume you have time out in B2 and time in in A2, rate per hour in H2

=MIN(B2-A2,8/24)*24*H2+MAX(0,B2-A2-8/24)*24*1.5*H2

format as number or currency

Regards,

Peo Sjoblom

"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

TRY THIS ONE 1 (0=12AM .5=12PM) RIGHT CLICK THE CELL THEN CHANGE FORMAT THEN
TIME. YOU DIVIDE 1 BY 24 TO GET PER HOUR

"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