I am currently trying to use the time format option within a Field Organiser with the format Hmm. However, I am using a 24 hour format at this is only picking up on any time prior to 10.00 or if it is 10.00 or 20.00 hours then it is converting to 1.00 and 2.00. When I use the HHmm format, it reads on everything above 10.00 but not below and I am missing a lot of times because of this.
How am I able to get a format that allows me to have all of my cells filled correctly so I can have the correctly formatted dates for time series analysis?
As discussed over the phone - the null time values were caused by a combination of appends of blank cells, and converting values containing "Total" to dates.