'Messy time input in a survey
I am looking for a way to clean a time input. Currently, it is a really messy one. Are there any methods to do that?
For example, I have a different types of time inputs such as 13, 13:00, 2pm, 1800 etc. and would like to compare this column with the entry time to see how many hours gone so need to normalize them. And I am sure it needs to be a method for it but can't really find anything.
I have two columns. One have generated time from the computer and the second was inputted by respondents of the survey in a various formats. So I am trying to compare both columns to see how many hours gone between entry and the exit. However, I have used timestamp and it doesn't work because of wrong inputs. So I am looking for an idea how to normalize time inputs.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|