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

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 <0CE96DCC-10E8-4A1A-8F78-D5659BEC1672@microsoft.com>,
"garpavco" <garpavco@discussions.microsoft.com> 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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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