Forum Discussion
VERY NEW to EXCEL
- Thank you very much, your help is greatly appreciated.
I will let you know how it turns out.
Dale
Thank you very much.
Is there a way to copy and paste the formula's into my spreadsheet,
Here is a copy of my spreadsheet, I use everyday, columns A,B and I will change from time to time, as my group changes.
Maybe I should have showed the spreadsheet in the first post.
My boss really has a thing for UPH.
| 3:30 PM | 6:00 PM | 8:00 PM | 10:00 PM | |||||
| 6:00 PM | 8:00 PM | 10:00 PM | 12:00 AM | |||||
| 2.50 Hrs | 2.00 Hrs | 2.00 Hrs | 2.00 Hrs | Total | UPH | |||
| ID NUMBER | NAME | 10 | 43 | 25 | 27 | 105 | 12.35 | COMMENTS |
| 8836 | TORY YOUNG | 0 | 0 | 0 | 0 | 0 | ||
| 8740 | ANTHONY SAMEC | 41 | 32 | 24 | 26 | 123 | ||
| 8138 | SANDRA ORR | 57 | 23 | 51 | 98 | 229 | ||
| 8978 | CLAUDREZ THOMPSON | 43 | 44 | 25 | 34 | 146 | ||
| 8945 | KIRK WILSON | 46 | 40 | 36 | 44 | 166 | ||
| 8947 | SCOTT BRALLIER | 43 | 46 | 49 | 51 | 189 | ||
| 8980 | TAYLOR WALTON | 28 | 21 | 32 | 25 | 106 | ||
| 8930 | STEVEN GUEVARA | 0 | 0 | 0 | 0 | 0 | ||
| 8931 | JEVELEISKA AVELLANET | 19 | 29 | 24 | 27 | 99 | start 4:30 | |
| 8987 | BROOKE CROTHERS | 40 | 52 | 31 | 40 | 163 | ||
| 8988 | CANDACE DELLAROVA | 9 | 25 | 23 | 27 | 84 | TEO UNTIL 5:00 THEN FO RECV. | |
| N/A | CLIFFORD WILLIAMS | 0 | 0 | 0 | 0 | 0 | TRASH AND CARDBOARD. |
You just have to change the cell references according to where the data is located in your spreadsheet. Your screenshot does not include row/column labels, but assuming the upper left corner is cell A1, then the formula for UPH in cell H5 would be:
=G5/SUMIF(C5:F5,">0",C$3:F$3)
For the hours in Row 3, you may just want to key in the number of hours instead of computing them in order to exclude the half hour that I assume is lunch.
- Thank you very much, your help is greatly appreciated.
I will let you know how it turns out.
Dale- JMB17
Have a question, can I use a IF statement to change the color of a cell?
So, say my Expectation's for my UPH was 25 so that cell would turn green and if lower than 25 turn red.
I have been reading about the IF statement but not sure how to use it to change the color of a cell.
Thanks
DaleLook at using conditional formatting. Click on the home tab, conditional formatting split button in the styles group, and select new rule. This will bring up a dialog box. Then, select "format only cells that contain and fill in your criteria and select your formatting:
There is also an option to "use a formula to determine which cells to format" for more complex/custom criteria - that may be to what your reference material is referring.