dar valor numerico estandar a las celdas y sumar al contener apellido de una persona, para contar hr

%3CLINGO-SUB%20id%3D%22lingo-sub-1742670%22%20slang%3D%22es-ES%22%3Egive%20standard%20numeric%20value%20to%20cells%20and%20add%20by%20containing%20a%20person's%20last%20name%2C%20to%20count%20hr%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1742670%22%20slang%3D%22es-ES%22%3E%3CP%3E%3CSPAN%3EGood%20morning.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E%20In%20my%20work%20I%20take%20care%20of%20the%20count%20of%20working%20hours%20according%20to%20the%20shifts.%20But%20shifts%20don't%20all%20have%20the%20same%20number%20of%20hours%20(mornings%2C%20afternoons%2C%20nights%2C%20holidays...).%20%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EI%20want%20when%20I%20put%20in%20the%20Excel%20table%20the%20last%20name%20of%20each%20companion%20in%20the%20corresponding%20shift%20cell%20I%20will%20do%20the%20time%20count%20of%20each%20one%20automatically.%3C%2FSPAN%3E%3CBR%20%2F%3E%20%3CSPAN%3ESo%20I%20don't%20have%20to%20do%20the%20sum%20every%20month%2C%20I%20do%20it%20in%20half%20an%20hour%20but%20I'm%20sure%20I%20can%20save%20it.%3C%2FSPAN%3E%3CBR%20%2F%3E%20%3CSPAN%3EA%20while%20ago%20I%20was%20told%20that%20you%20could%20and%20sent%20me%20an%20example%2C%20but%20I%20didn't%20understand%20the%20formula.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E%20Any%20ideas%3F%20Thank%20you!%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1742670%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1743051%22%20slang%3D%22de-DE%22%3ESubject%3A%20dar%20valor%20numerico%20estandar%20a%20las%20celdas%20y%20sumar%20al%20contener%20apellido%20de%20una%20persona%2C%20para%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1743051%22%20slang%3D%22de-DE%22%3EWith%20your%20permission%2C%20if%20I%20can%20recommend%20you%2C%20add%20a%20file%20(without%20sensitive%20data)%20to%20your%20project.%3CBR%20%2F%3EExplain%20your%20plans%20in%20relation%20to%20this%20file.%3CBR%20%2F%3ESo%20you%20can%20get%20a%20solution%20that%20is%20tailored%20to%20your%20needs%20much%20faster.%3CBR%20%2F%3EAt%20the%20same%20time%2C%20it%20is%20much%20easier%20for%20someone%20who%20wants%20to%20help%20understand%20the%20subject.%3CBR%20%2F%3EA%20win-win%20situation%20for%20everyone.%20%3CBR%20%2F%3E%20*%20Knowing%20the%20Excel%20version%20and%20operating%20system%20would%20also%20be%20an%20advantage.%3CBR%20%2F%3E%3CBR%20%2F%3EThank%20you%20for%20your%20understanding%20and%20patience%20%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%20Nikolino%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20I%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Buenos días.
En mi trabajo me encargo del recuento de horas de trabajo según los turnos. Pero los turnos no tienen todos el mismo número de horas (mañas, tardes, noches, festivos...).
Quiero que al poner en la tabla de Excel el apellido de cada compañero en la celda del turno correspondiente me haga el recuento de horas de cada uno de forma automática.
Para así no tener que hacer la suma cada mes, que la hago en media hora pero seguro que me la puedo ahorrar.
Hace un tiempo me dijeron que se podía y me mandaron un ejemplo, pero no entendí la fórmula.
¿Alguna idea? ¡Gracias!

1 Reply
Highlighted
With your permission, if I can recommend you, add a file (without sensitive data) to your project.
Explain your plans in relation to this file.
So you can get a solution that is tailored to your needs much faster.
At the same time, it is much easier for someone who wants to help to understand the subject.
A win-win situation for everyone.
* Knowing the Excel version and operating system would also be an advantage.

Thank you for your understanding and patience


Nikolino

I know I don't know anything (Socrates)