User Profile
Kirkoid
Copper Contributor
Joined 2 years ago
User Widgets
Recent Discussions
Using MOD in Data Validation
Hey all, I hope you can help. I've got a Workbook that logs mental health presentations at a hospital. I need people to enter the date and time in a column in the format dd/mm/yyyy hh:mm. You would not believe how hard this seems to be for them, or the creative ways in which they enter the date and time and (it seems) anything else they can think of! I've asked them to enter it in as dd/mm/yyyy hh:mm and used Format Cells to specify [$en-GB]dd mmm yyyy hh:mm (so we can see the month and avoid any mix-ups with US format) and custom Data Validation with the formula =MOD(A3,2) which seems to work half the time. The problem is when the time is 00:00 (which it defaults to when not entered with the date, not a problem, desirable even), some of the time this appears to be unacceptable and you have to put a different time in (we've been using 00:01). Any ideas as to why and a way around it?Solved2.6KViews0likes10Comments
Groups
Recent Blog Articles
No content to show