overtime calculation in 1 cell
 

TRYING TO, IN ONLY 1 CELL, MULTIPLY 8 HRS X REG. RATE, PLUS ADD ANY HOURS
OVER 8 X 1/12 & COME OUT WITH 1 TOTAL. ANY SUGGESTIONS?

EXAMPLE: 9 HRS (8HRS X $10) + (1 HOUR X $15) = TOTAL
WHILE STILL BEING ABLE TO CHANGE THE CELL WHICH REFERENCES THE HOURS WORKED:
10 HRS (8HRS X $10) + (2 HOURS X $15), ETC... (FIXED CELL FOR THE RATE, WITH
CHANGEABLE CELL FOR HOURS WORKED)
--
Cliff

See my answer to your previous post

In article ,
"garpavco" wrote:

TRYING TO, IN ONLY 1 CELL, MULTIPLY 8 HRS X REG. RATE, PLUS ADD ANY HOURS
OVER 8 X 1/12 & COME OUT WITH 1 TOTAL. ANY SUGGESTIONS?

EXAMPLE: 9 HRS (8HRS X $10) + (1 HOUR X $15) = TOTAL
WHILE STILL BEING ABLE TO CHANGE THE CELL WHICH REFERENCES THE HOURS WORKED:
10 HRS (8HRS X $10) + (2 HOURS X $15), ETC... (FIXED CELL FOR THE RATE, WITH
CHANGEABLE CELL FOR HOURS WORKED)