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

G

garpavco

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

JE McGimpsey

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...
 
P

Peo Sjoblom

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
 
R

RODY

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
 
Top