View Single Post
  #1   Report Post  
garpavco
 
Posts: n/a
Default 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