How do I get a letter to represent a number for scheduling?

H

Henry Elliott

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
 
P

Peo Sjoblom

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I assign a numeric value to a letter 2
How to add (sum) a row cells with letter(s) aside or without numbe 12
How do I create shiftwork schedules in Exel? 0
How do I accomplish this? 2
how do I set up time worked in excell spreadsheet 1
Assigning number value to letters 1
Schedule 1
excel: How do I setup a function to put any numbers over 80 into . 2

Top