G Guest Jan 5, 2005 #1 TRYING TO CALCULATE 8 HRS STRAIGHT TIME, IN ADDITION TO ANY HOURS OVER 8 MULTIPLY BY 1 1/2 IN THE SAME CELL
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 Jan 5, 2005 #2 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...
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...
G Guest Jan 5, 2005 #3 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
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
G Guest Aug 18, 2005 #4 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
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
