EirikDaude
02-06-2013, 05:06 AM
I'm having a spreadsheet in which the user is entering the time at which a task is finished. Because this time is later used to calculate the difference between when the task was planned to be done I also need the date, but since I don't want the sheet to look to messy, I'd prefer not to have to display it. I'd also like to avoid using an input-box/form to enter the information.
Now, the problem is that the input-format for dates varies from computer to computer (and maybe from user to user as well) where the worksheet can be accessed. What I'd like is for the user to put in e.g. "6/2 11:00", and for that to then be identified as the 6th of February of the current year by the worksheet. So is there any way to force this? Currently there's a fair chance for it to be interpreted as the 2nd of June, depending a bit on where/who puts it in.
Attaching a sample sheet from the workbook, for those in need of a more visual aid :)
Now, the problem is that the input-format for dates varies from computer to computer (and maybe from user to user as well) where the worksheet can be accessed. What I'd like is for the user to put in e.g. "6/2 11:00", and for that to then be identified as the 6th of February of the current year by the worksheet. So is there any way to force this? Currently there's a fair chance for it to be interpreted as the 2nd of June, depending a bit on where/who puts it in.
Attaching a sample sheet from the workbook, for those in need of a more visual aid :)