I am calling time data that appears as 2:00 AM. How can I change it to appear as 2am in the cell? Ideally, I would like to add something that would insert the time zone this way: 2am ET
This is info pulled from an API into Google Sheets.
Also, I may be in Win XP, not Win 7.
Thanks!
message edited by kc64
I don't use Google sheets, so the best I can offer is a Custom Cell Format for Excel, which gets you close, but not exact: This Custom Cell Format...
h AM/PM "ET"
...will return...
2 AM ET
I also want to point out one possible issue:
Very often, Time and Date data that is downloaded into Excel from other applications or perhaps a website look like Times and Dates, but are often simply text. Regardless of how you try to format the cell, there are times when you cannot change the format and turn the text into a Time/Date. You can go through the normal steps to change the format, but it won't change the way the contents of the cell are displayed.
I don't know if Google Sheets will exhibit this issue, but I just want you to be aware of it so that you don't pull your hair out trying to figure out why your formatting attempts aren't working.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.