|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"
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.