Microsoft Excel - excel_calculo_horas_extras_formulas [Modo de Compatibilidade]

CONTROLE DE HORASCLCULO DE HORAS EXTRAS9:00:001:0024:00:00FUNCIONRIO:Fernando Henrique Cardoso dos Santos5:0017:001CALCULAR UM MS INTEGRALCALCULAR O PERODO DE UM MS A OUTROhttp://www.saberexcel.comReferente aFevereiroeMaro0:011:00DIA DODIA DAFERIADOHORRIOALMOOABATERHORAHORAADICIONALTOTAL0:00MSSEMANAENTRADASADAEXTRAEXTRA 50%D.S.R.ACUMUL.SEMANAFERIADOSALMOO1-FebQuinta0:000:0015:00:000:00:0023:001:0051Domingo2-FebSexta0:000:0015:00:000:00:0023:001:0062Segunda3-FebSbado0:000:0015:00:000:00:0023:001:0073Tera4-FebDomingo0:000:0015:00:000:00:0023:001:0014Quarta5-FebSegunda0:000:0015:00:000:00:0023:001:0025Quinta6-FebTera0:000:0015:00:000:00:0023:001:0036Sexta7-FebQuarta0:000:0015:00:000:00:0023:001:0047Sbado8-FebQuinta0:000:0015:00:000:00:0023:001:0059-FebSexta0:000:0015:00:000:00:0023:001:00610-FebSbado0:000:0015:00:000:00:0023:001:00711-FebDomingo0:000:0015:00:000:00:0023:001:00112-FebSegunda0:000:0015:00:000:00:0023:001:00213-FebTera0:000:0015:00:000:00:0023:001:00314-FebQuarta0:000:0015:00:000:00:0023:001:00415-FebQuinta0:000:0015:00:000:00:0023:001:00516-FebSexta0:000:0015:00:000:00:0023:001:00617-FebSbado0:000:0015:00:000:00:0023:001:00718-FebDomingo0:000:0015:00:000:00:0023:001:00119-FebSegunda0:000:0015:00:000:00:0023:001:00220-FebTera0:000:0015:00:000:00:0023:001:00321-FebQuarta0:000:0015:00:000:00:0023:001:00422-FebQuinta0:000:0015:00:000:00:0023:001:00523-FebSexta0:000:0015:00:000:00:0023:001:00624-FebSbado0:000:0015:00:000:00:0023:001:00725-FebDomingo0:000:0015:00:000:00:0023:001:00126-FebSegunda0:000:0015:00:000:00:0023:001:00227-FebTera0:000:0015:00:000:00:0023:001:00328-FebQuarta0:000:0015:00:000:00:0023:001:0041-MarQuinta0:000:0015:00:000:00:0023:001:0052-MarSexta0:000:0015:00:000:00:0023:001:0063-MarSbado0:000:0015:00:000:00:0023:001:007TOTAL0:000:00240:00SALRO