用什么公式可以计算考勤时间段的工时结果,表格如下?答:I2单元格输入公式=IF(SUMPRODUCT((TEXT(E$2:E2,"YYYY-MM-DD")=TEXT(E2,"YYYY-MM-DD"))*1)=1,TEXT(MAX(IF(TEXT(E$2:E$100,"YYYY-MM-DD")=TEXT(E2,"YYYY-MM-DD"),E$2:E$100))-MIN(IF(TEXT(E$2:E$100,"YYYY-MM-DD")=TEXT(E2,"YYYY-MM-DD"),E$2:E$100)),"H...