=IF(AND(ISNUMBER(B2),ISNUMBER(C2)),(C2-B2)24-IF(AND(B2<“13:00”1,C2>”12:00″*1),1,0),0)
利唐i人事HR社区,发布者:HR数字化研究员,转转请注明出处:https://www.ihr360.com/hrnews/20241226012.html
=IF(AND(ISNUMBER(B2),ISNUMBER(C2)),(C2-B2)24-IF(AND(B2<“13:00”1,C2>”12:00″*1),1,0),0)
利唐i人事HR社区,发布者:HR数字化研究员,转转请注明出处:https://www.ihr360.com/hrnews/20241226012.html