莫丁的博客

什么都有一些

如何在日期时间单元格筛选出特定时间段记录

在H单元格右侧增加一列I

H3为源单元格, I3为结果单元格


两个时间段


I3=IF(OR(AND(RIGHT(H3,LEN(H3)-FIND(" ",H3))>"00:00",RIGHT(H3,LEN(H3)-FIND(" ",H3))<"06:00"),AND(RIGHT(H3,LEN(H3)-FIND(" ",H3))>"00:00",RIGHT(H3,LEN(H3)-FIND(" ",H3))<"06:00")),TRUE,FALSE)


1个时间段


I3=IF(OR(AND(RIGHT(H3,LEN(H3)-FIND(" ",H3))>"00:00",RIGHT(H3,LEN(H3)-FIND(" ",H3))<"06:00")),TRUE,FALSE)


相关搜索语:

如何在日期时间单元格筛选出特定时间段记录



发表评论:

◎欢迎参与讨论,请在这里发表您的看法、交流您的观点。

Powered By Z-BlogPHP 1.7.1

Copyright 2006-2021 莫丁