When we push date and time values to a google spreadsheet in the format d/m/Y H:i a (eg. 25/12/2015 1:43 pm) the date and time is displayed inconsistently, see below:
Any idea why the format is not consistent in google spreadsheets and how we can ensure it is?