GLOBE Students!

The GLOBE Clouds team is hoping you are all collecting observations or downloading and analyzing clouds data for the upcoming U.S. Student Research Symposia or the International Virtual Science Symposium. If you are using data downloaded from the GLOBE site, you will see a T between the date and time of the observations (example - 2018-10-01T14:00:00). 

Image result for helen amos


We got together with Dr. Helen Amos, who put together steps on how to take the "T" out using Excel and Google sheets. The result is having a date and time that looks like 2018-04-13T16:27:00 UTC to looking like 13/4/2018 11:27:00 local time.

Use this blog post to help you come up with a research question! 


//////////////////////////////////////////     Using Excel    ////////////////////////////////////////// 



Use the SUBSTITUTE function to replace the "T" with a space " ". Then adjust for the timezone you want.  I want New York time. New York is 5 hours behind UTC, so it's -(5/24). Tokyo is 9 hours ahead of UTC and would be +(9/24). The result of Step 1 is a decimal number that won't make sense. Go to Step 2.  


Select the cell with the decimal number (here it's B2) and customize the format. 

Click "OK" and you're good to go. Here is what the final result looks like:


/////////////////////////////////////     Using Google Sheets    /////////////////////////////////////  


Step 1 in Google Sheets: Same as Step 1 in Excel

Step 2 in Google Sheets: Customize the date time format to what you want. 

and you are done!


Reach out to the GLOBE Clouds team my adding a comment or sending your questions to .

Don't forget to review the tips on how to come up with a good research question -



Colón Robles, Marilé

GLOBE Clouds Lead

More Blog Entries