Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I get a letter to represent a number for scheduling?
I am creating a schedule. I use letters to indicate the position that person
is working for that shift. For example: P=7.5 hour. M=7.75 hour S=6.5 hours and so on. I need to keep track of the hours an employee works that week for overtime is taboo. I want to use letters in the row the auto sum at the end of the row for that week to determine if that employee has gone over 40 hours that week. Is there a way for me to accomplish this??? Thank You for your help. Henry Elliott |
#2
|
|||
|
|||
One way
=SUMPRODUCT(COUNTIF(A2:A6,{"P";"M";"S"}),{7.5;7.75 ;6.5}) where A2:A8 holds the worked week adapt to fit to include the other shift keys Regards, Peo Sjoblom "Henry Elliott" wrote: I am creating a schedule. I use letters to indicate the position that person is working for that shift. For example: P=7.5 hour. M=7.75 hour S=6.5 hours and so on. I need to keep track of the hours an employee works that week for overtime is taboo. I want to use letters in the row the auto sum at the end of the row for that week to determine if that employee has gone over 40 hours that week. Is there a way for me to accomplish this??? Thank You for your help. Henry Elliott |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
Random Number Questions | Excel Worksheet Functions | |||
How to format a number in Indian style in Excel? | Excel Discussion (Misc queries) | |||
Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |