我有15分钟的时间间隔的96次列表，我试图用于数据验证。事实证明，它仅能达到一定程度。从00:00到18:30选择时间时，它可以正常工作。从18:45到23:45选择时间时，会引发错误。
您在单元B1中输入的数据违反了数据验证
在此单元格上设置的规则。
我制作了一个测试文件，以查看如果使用其他类型的数据，但是使用数字列表或文本的列表，它似乎没有问题时，它是否会发生。
有人知道为什么它与时间列表不起作用的原因吗？更重要的是，有人知道我可以使它起作用的方法吗？
编辑：
Player0提供的步骤努力将其修复在上面链接的我的测试文件中，但没有改变我正在处理的真实文件。这是表现出相同问题的真实文件的副本。
请尝试在几个单元格中设置超过18:30的时间。我不断遇到相同的错误。
我想解决方法可能是不要拒绝无效数据的输入，但是我觉得这应该可以拒绝它并想知道我在哪里出错。
I have a list of 96 times in 15 minute intervals that I'm trying to use for data validation. It turns out that it works only up to a certain point. When selecting times from 00:00 to 18:30 it works fine. When selecting times from 18:45 to 23:45 it throws an error.
The data that you entered in cell B1 violates the data validation
rules set on this cell.
I made a test file to see if the same thing would happen if I used a different type of data, but when using a lists of numbers or text with the same amount of items it seems to work without issues.
https://docs.google.com/spreadsheets/d/1ClBhZk6fysOq0wqIrE5IxJgPMs_A05gJsN_kEiXoFGI/edit?usp=sharing
Does anyone know the reason why it doesn't work with the list of times? More importantly, does anyone know a way I could get it to work?
Edit:
The steps provided by player0 worked to fix it in my test file linked above, but didn't make a difference in the real file I'm working on. Here's a copy of the real file which exhibits the same problem.
https://docs.google.com/spreadsheets/d/1cOMB0BpzSBR7ZM7fJQQfhA56fniKTBJb-3TePUky6gM/edit?usp=sharing
Please try setting a time of greater than 18:30 in a couple of cells. I keep getting the same errors.
I suppose a workaround could be to not reject input on invalid data, but I feel this should just work with rejecting it and would like to know where I went wrong.
发布评论
评论（1）
格式化。选择列A＆amp; B和强制时间（或纯文本）：
formatting. select columns A & B and force Time (or Plain text):