莫丁的博客

什么都有一些

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

在H单元格右侧增加一列IH3为源单元格, 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
<< 1 >>

Powered By Z-BlogPHP 1.7.1

Copyright 2006-2021 莫丁