Forum Discussion
Solved
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 n...
I wasn't suggesting that you should forget to record the hours, just that the user input might be better supported if the two elements were collected separately. For example:
I went fairly wild with the number formatting but the idea was to show that you could have your cake and eat it when it comes to presenting usable data.
If all users use the desktop version of Excel for Windows or Mac, you could use VBA code (the Worksheet_Change event procedure) to check that the entry is a date/time value within the specified range.
Unfortunately they use a combo of desktop version, SharePoint and Teams, and don't distinguish between them. I think I will keep the current solution in place for a week or so to 'train' them on how to enter a date into Excel then remove it,