Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
WHAT'S THE FORMULA FOR CALCULATING OVERTIME IN 1 CELL? EXAMPLE: 8. | Excel Worksheet Functions | |||
overtime calculation in 1 cell | Excel Worksheet Functions | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
GET.CELL | Excel Worksheet Functions | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |