如果时间单元格的IF公式不起作用 [英] IF formula on time cell not working

问题描述

IF(AND(H$2>=$B2,H$2<=$C2),"X","") 

适用于 08:30-15:30 和 9:30-18:30 ，但它适用于班次 19:30-4:30 检查图像(以黄色单元格突出显示)

Works for 08:30-15:30 and 9:30-18:30, but it does for shift 19:30-4:30 check the image (highlighted in yellow cell)

推荐答案

简单"的解决方案是检查start是否大于end.在这种情况下，您需要检查

A "simple" solution would be to check if start is bigger than end. In that case, you will need to check for

time >= start OR time <= end

类似的东西:

=IF(
    $B2<$C2;
        IF(AND(H$2>=$B2;H$2<=$C2);"X";"");
        IF(OR( H$2>=$B2;H$2<=$C2);"X";"")
)

这篇关于如果时间单元格的IF公式不起作用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！