时间框架之间的Excel公式

Question

不确定stack是否也接受/允许一般的excel问题，但我想我还是会问。查找excel公式的帮助，该公式检查一列中的时间并返回另一列中的移位(白天，晚上或过夜)。我有夜班和夜班输出正确，但由于某种原因，白班没有?

下面是两个excel公式:

=IF(AND(HOUR(Table8[@Time]) >7, HOUR(Table8[@Time] <15)),"1st shift")

=IFS(AND(HOUR([@Time]) >= 7, HOUR([@Time] <= 15)), "1st shift", AND(HOUR([@Time]) >= 15, HOUR([@Time]) <= 23), "2nd shift", OR(HOUR([@Time]) >= 23, HOUR([@Time]) <= 7), "3rd shift")

Answer 1

括号是问题所在

像这样检查

= IFS(和(小时([@Time])祝辞= 7小时([@Time]) & lt; = 15),"1日shift",和(小时([@Time])祝辞= 15小时([@Time]) & lt; = 23),"2日shift",或(小时([@Time])祝辞= 23小时([@Time]) & lt; = 7),"第三shift")

Answer 2

对于第一次移位的第二次检查，您将括号放在了错误的位置

这是正确的:=IFS(AND(HOUR([@Time]) >= 7, HOUR([@Time]) <= 15), "1st shift", AND(HOUR([@Time]) >= 15, HOUR([@Time]) <= 23), "2nd shift", OR(HOUR([@Time]) >= 23, HOUR([@Time]) <= 7), "3rd shift")

HOUR([@Time] <= 15)错误