1J31,1J32 ,1J33,1J38 1J36,1J116,1J117 1J87,1J88,1J89 ,1J90,1J911J751J77C,1J79C,1J85C,1J87C,1J92,1J93,1J94,1J951J46,1J50,1J54,1J76,1J77,1J79,1J80,1J85,1J86,1J34,1J51,1J52,1J65,1J66,1J67,1J83,1J4031J30,1J31,1J321
6、每天的迟到和加班时间数计算出来了,接下来我们需要计算整个月的迟到和加班时间数。在I33单元格输入公式=TEXT(SUM(I2:I32),"[H]:M");在J33单元格输入公式=TEXT(SUM(J2:J32),"[H]:M")。TEXT函数的意思是根据指定的数值格式将数字转成文本。如果直接相加是不能得出正确的时间总数的。如...