神马品牌网7.3武器战士手法:Excel 中对时间的筛选
来源：百度文库 编辑：神马品牌网 时间：2024/05/03 00:15:18
打卡时间
2006-7-26 7:31:26
2006-7-26 7:31:26
2006-7-26 11:59:03
2006-7-26 11:59:03
2006-7-26 14:15:41
2006-7-26 14:15:41
2006-7-26 18:35:53
2006-7-26 18:35:53
2006-7-27 7:31:22
2006-7-27 7:31:22
2006-7-27 11:51:12
2006-7-27 11:51:12
2006-7-27 14:18:44
2006-7-27 14:18:44
2006-7-27 18:28:19
2006-7-27 18:28:19
2006-7-28 7:36:05
2006-7-28 7:36:05
2006-7-28 11:49:23
2006-7-28 11:49:23
2006-7-28 14:11:03
2006-7-28 14:11:03
2006-7-28 18:37:34
2006-7-28 18:37:34
2006-7-29 7:37:51
2006-7-29 7:37:51
2006-7-29 12:00:08
2006-7-29 12:00:08
2006-7-29 14:14:04
2006-7-29 14:14:04
2006-7-29 20:10:46
2006-7-29 20:10:46
2006-7-30 7:41:18
2006-7-30 7:41:18
2006-7-30 12:04:21
2006-7-30 12:04:21
2006-7-30 14:15:25
2006-7-30 14:15:25
2006-7-30 18:27:41
2006-7-30 18:27:41
2006-7-31 7:49:02
2006-7-31 7:49:02
2006-7-31 11:42:33
2006-7-31 11:42:33
2006-7-31 14:16:58
2006-7-31 14:16:58
2006-7-31 18:30:09
2006-7-31 18:30:09
2006-8-1 7:25:53
2006-8-1 7:25:53
2006-8-1 11:58:35
2006-8-1 11:58:35
2006-8-1 14:29:11
2006-8-1 14:29:11
2006-8-1 18:38:06
2006-8-1 18:38:06
2006-8-2 7:27:49
2006-8-2 7:27:49
2006-8-2 12:08:03
2006-8-2 14:21:23
2006-8-2 18:41:18
2006-8-3 7:36:57
2006-8-3 12:00:30
2006-8-3 14:25:39
2006-8-3 18:34:12
2006-8-4 7:55:59
2006-8-4 11:56:59
2006-8-4 14:21:03
2006-8-4 18:21:45
2006-8-5 7:30:45
2006-8-5 18:22:02
2006-8-6 7:31:43
2006-8-6 12:26:14
2006-8-6 18:16:59
2006-8-7 7:41:39
2006-8-7 11:45:41
2006-8-7 14:19:47
2006-8-8 7:45:58
2006-8-8 14:27:19
2006-8-9 7:55:53
2006-8-10 7:42:30
2006-8-10 11:51:13
2006-8-10 14:20:30
2006-8-10 18:19:46
2006-8-11 7:53:01
2006-8-11 14:21:54
2006-8-11 18:22:26
2006-8-12 7:41:05
2006-8-12 11:55:17
2006-8-12 13:33:12
2006-8-12 18:32:24
2006-8-13 7:41:35
2006-8-13 11:51:56
2006-8-13 14:21:36
2006-8-13 16:52:52
2006-8-14 7:29:44
2006-8-14 11:48:16
2006-8-14 14:20:09
2006-8-14 18:50:36
2006-8-17 7:51:44
2006-8-17 11:58:19
2006-8-17 18:22:06
2006-8-18 7:54:00
2006-8-18 11:44:29
2006-8-18 14:16:51
2006-8-18 18:16:50
2006-8-19 7:57:14
2006-8-19 11:46:26
2006-8-19 14:17:53
2006-8-19 18:26:37
2006-8-20 7:41:37
2006-8-20 14:13:43
2006-8-20 20:13:58
2006-8-21 7:51:55
2006-8-21 11:45:21
2006-8-21 14:13:32
2006-8-21 18:25:01
2006-8-22 8:00:16
2006-8-22 11:46:48
2006-8-22 14:17:15
这是一个单元格里的内容,我该怎么把上午8点以前12点以后;下午2点30以前6点30以后的选出来,其余的删除
每行是一个单元格的
2006-7-26 7:31:26
2006-7-26 7:31:26
2006-7-26 11:59:03
2006-7-26 11:59:03
2006-7-26 14:15:41
2006-7-26 14:15:41
2006-7-26 18:35:53
2006-7-26 18:35:53
2006-7-27 7:31:22
2006-7-27 7:31:22
2006-7-27 11:51:12
2006-7-27 11:51:12
2006-7-27 14:18:44
2006-7-27 14:18:44
2006-7-27 18:28:19
2006-7-27 18:28:19
2006-7-28 7:36:05
2006-7-28 7:36:05
2006-7-28 11:49:23
2006-7-28 11:49:23
2006-7-28 14:11:03
2006-7-28 14:11:03
2006-7-28 18:37:34
2006-7-28 18:37:34
2006-7-29 7:37:51
2006-7-29 7:37:51
2006-7-29 12:00:08
2006-7-29 12:00:08
2006-7-29 14:14:04
2006-7-29 14:14:04
2006-7-29 20:10:46
2006-7-29 20:10:46
2006-7-30 7:41:18
2006-7-30 7:41:18
2006-7-30 12:04:21
2006-7-30 12:04:21
2006-7-30 14:15:25
2006-7-30 14:15:25
2006-7-30 18:27:41
2006-7-30 18:27:41
2006-7-31 7:49:02
2006-7-31 7:49:02
2006-7-31 11:42:33
2006-7-31 11:42:33
2006-7-31 14:16:58
2006-7-31 14:16:58
2006-7-31 18:30:09
2006-7-31 18:30:09
2006-8-1 7:25:53
2006-8-1 7:25:53
2006-8-1 11:58:35
2006-8-1 11:58:35
2006-8-1 14:29:11
2006-8-1 14:29:11
2006-8-1 18:38:06
2006-8-1 18:38:06
2006-8-2 7:27:49
2006-8-2 7:27:49
2006-8-2 12:08:03
2006-8-2 14:21:23
2006-8-2 18:41:18
2006-8-3 7:36:57
2006-8-3 12:00:30
2006-8-3 14:25:39
2006-8-3 18:34:12
2006-8-4 7:55:59
2006-8-4 11:56:59
2006-8-4 14:21:03
2006-8-4 18:21:45
2006-8-5 7:30:45
2006-8-5 18:22:02
2006-8-6 7:31:43
2006-8-6 12:26:14
2006-8-6 18:16:59
2006-8-7 7:41:39
2006-8-7 11:45:41
2006-8-7 14:19:47
2006-8-8 7:45:58
2006-8-8 14:27:19
2006-8-9 7:55:53
2006-8-10 7:42:30
2006-8-10 11:51:13
2006-8-10 14:20:30
2006-8-10 18:19:46
2006-8-11 7:53:01
2006-8-11 14:21:54
2006-8-11 18:22:26
2006-8-12 7:41:05
2006-8-12 11:55:17
2006-8-12 13:33:12
2006-8-12 18:32:24
2006-8-13 7:41:35
2006-8-13 11:51:56
2006-8-13 14:21:36
2006-8-13 16:52:52
2006-8-14 7:29:44
2006-8-14 11:48:16
2006-8-14 14:20:09
2006-8-14 18:50:36
2006-8-17 7:51:44
2006-8-17 11:58:19
2006-8-17 18:22:06
2006-8-18 7:54:00
2006-8-18 11:44:29
2006-8-18 14:16:51
2006-8-18 18:16:50
2006-8-19 7:57:14
2006-8-19 11:46:26
2006-8-19 14:17:53
2006-8-19 18:26:37
2006-8-20 7:41:37
2006-8-20 14:13:43
2006-8-20 20:13:58
2006-8-21 7:51:55
2006-8-21 11:45:21
2006-8-21 14:13:32
2006-8-21 18:25:01
2006-8-22 8:00:16
2006-8-22 11:46:48
2006-8-22 14:17:15
这是一个单元格里的内容,我该怎么把上午8点以前12点以后;下午2点30以前6点30以后的选出来,其余的删除
每行是一个单元格的
用鼠标选定本页面你提问框中的数据范围,点"复制",打开EXECL,点"粘贴",你的数据就变成一列数据了。
再点"数据"->"筛选"->"自动筛选",点第一行的倒三角形,点"自定义",就可按你的要求筛选出不需要的数据了。
直接在Excel操作是做不到的，方法有两个：
1、自己去学一下Excel的VBA编程，学起来挺麻烦的
2、导入Oracle或sql server等数据库，然后在数据库中用sql语句操作，做完再导出来，不会难的
如果有加50分以上的我帮你做，：）
一个单元格里的内容 怎么筛选？！