用Excel制作自动记录的考勤表

guanli.1kejian.comguanli.1kejian.comExcelwuaihui1010ExcelExcel20021.Excel20022004122.A1B1A21A2A31113.C1-1171C1714.5.d1.222.=now()1.2.B2Excel333.CtrlB3B3guanli.1kejian.comguanli.1kejian.com4.ShiftCtrlB4413:3013:301.552.Y2=COUNTIF(C2:X2,830)8:30Z28:30Z2=COUNTIF(C3:X3,1700)17:00)Z217:003.AB2=COUNTIF(C2:X3,)AB24.Excel5.guanli.1kejian.comguanli.1kejian.comExcel2003ICExcelExcel2003office20031-11211111231281guanli.1kejian.comguanli.1kejian.com3Tab1Sheet124ExcelExcelguanli.1kejian.comguanli.1kejian.comExcelExcel12OLEwordword1.H52.B3[]3!$H$5H5OLEwordOLEwordExcelwordExcel/Micrsoftword[]4OLEwordguanli.1kejian.comguanli.1kejian.comwordOLEwordOLEwordExcelwordExcel/Micrsoftword[]4OLEwordword