=IF(AND(ISBLANK(H8),ISBLANK(F8)),"休息",IF(OR(ISBLANK(H8),ISBLANK(F8)),"缺勤",IF(K8>720,"加班","早退")))
=VALUE(TEXT(H4-F4,"[m]"))----将小时转换成分钟
=HOUR(J8)*60+MINUTE(J8)-----将小时转换成分钟
=IF(AND(ISBLANK(H8),ISBLANK(F8)),"休息",IF(OR(ISBLANK(H8),ISBLANK(F8)),"缺勤",IF(K8>720,"加班","早退")))
=VALUE(TEXT(H4-F4,"[m]"))----将小时转换成分钟
=HOUR(J8)*60+MINUTE(J8)-----将小时转换成分钟