GISN & STEM Professionals' Blog - GLOBE International STEM Network

Data Data Everywhere! #1: How to get the 'T' out! You may have noticed that the time format when you retrieve data from the GLOBE web site recently changed. The new format is YYYY-MM-DD T HH:MM:SS.   We would like to show a quick and easy way to go back to the time format MM/DD/YYYY HH:MM:SS. 1) Select the column that has the time format you want to change. 2) Copy the column to a  new location  on your spreadsheet; you do not want to manipulate the original column directly, to avoid losing data. 3) Make sure there is a  blank  column ...