horario en excel

8
CENTRO MEDICO LA SAMARITANA LTDA JULIO DE 2014 SISTEMAS S D L M MI J V S D L M MI J V S D L M MI J V S D L M MI J V S D 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 1 2 3 JUAN CARLOS FIGUEROA N N N N N T C C N N N N JESÚS ORDOÑEZ M M T N N N N N M/N N N N M/N N N N T KEVIN MAURICIO MORA M T T T MI C M N C C C C C T C C C C C C C C C C C C ANDREY GALVIS T M M M MI M M M T M MI M M C ANDREY GALVIS N N N T N N N M/N N=NOCHE 06:00 PM A 06:00 AM T=TARDE 01:00 PM A 06:00 PM M=MAÑANA 06:00 A 12:00 PM M/T= MAÑANA NOCHE 06:00 AM A 12:00 PM Y 06:00 PM A 06:00 PM

Upload: jesus-antonio-figueroa-guerrero

Post on 25-Sep-2015

229 views

Category:

Documents


3 download

DESCRIPTION

realizar un horario en excel

TRANSCRIPT

Hoja1

CENTRO MEDICO LA SAMARITANA LTDA

JULIO DE 2014SISTEMASSDLMMIJVSDLMMIJVSDLMMIJVSDLMMIJVSD5678910111213141516171819202122232425262728293031123JUAN CARLOS FIGUEROANNNNNTCCNNNNJESS ORDOEZMMTNN NNNM/NNNNM/NNNNTKEVIN MAURICIO MORAMTTTMICMNCCCCCTCCCCCCCCCCCCANDREY GALVISTMMMMIMMMTMMIMMCANDREY GALVISNNNTNNNM/N

N=NOCHE 06:00 PM A 06:00 AM T=TARDE 01:00 PM A 06:00 PM M=MAANA 06:00 A 12:00 PM M/T= MAANA NOCHE 06:00 AM A 12:00 PM Y 06:00 PM A 06:00 PM

Hoja2NOMBRES Y APELLIDOSRECARGO_NOCTURNORECARNO_NOCTURNO_DOMINICALRECARGO_FESTIVO O DOMINICALHORAS_EXTRAS_DOMINICALESJUAN CARLOS FIGUEROA60122210JESS ORDOEZ104161814KEVIN MAURICIO MORA26610ANDREY GALVIS48261612TOTAL214606246$ 741,510$ 385,000$ 278,484$ 236,133$ 1,641,127

Hoja3

CENTRO MEDICO LA SAMARITANA LTDA

AGOSTO DE 2014SISTEMASLMMIJVSDLMMIJVSDLMMIJVSDLMMIJVSD45678910111213141516171819202122232425262728293031JUAN CARLOS FIGUEROACOCOCOCCOCOCOCOCOCOCOCOCOCOCOCOCOCOCOCOCOCOCOJESS ORDOEZNNNM/NNNNTNNNM/NNNNTKEVIN MAURICIO MORACOCOCOCOCOCOCOCOCOCOCOCCOCOCOCOCOCOCOCOCOCOCOANDREY GALVISNNNTNNNM/NNNNTNNNM/N

N=NOCHE 06:00 PM A 06:00 AM T=TARDE 12:00 AM A 06:00 PM M=MAANA 06:00 A 12:00 PM C= 6AM A 6PMCO= 8AM - 12AM Y 2PM - 6PM

Hoja4

PUNTO VIVE DIGITAL CIAF LA LIBERTADJESS ANTONIO FIGUEROA [email protected] DE 2014SISTEMASLMMIJVSDLMMIJVSDLMMIJVSDLMMIJVSD123456789101112131415161718192021222324252627282930ESCRIBA SU NOMBRECOCOCOCCOCOCOCOCOCOCOCOCOCOCOCOCOCOCOCOCOCOCONOMBRE DE UN COMPAERONNNM/NNN
Jesus A. Figueroa Guerrero: Jesus A. Figueroa Guerrero:JUAN CARLOS EMPIEZA EL TURNONTNNNM/NNNNTNOMBRE DE UN COMPAEROCOCOCOCOCOCOCOCOCOCOCOCCOCOCOCOCOCOCOCOCOCOCONOMBRE DE UN COMPAERONNNTNNNM/NNNNTNNNM/N

N=NOCHE 06:00 PM A 06:00 AM T=TARDE 12:00 AM A 06:00 PM M=MAANA 06:00 A 12:00 PM C= 6AM A 6PMCO= 8AM - 12AM Y 2PM - 6PM