In Google Sheets, how to convert [2021-10-08 23:49:37] to a (-6) time zone and look like [10-October-CodePudding

Home > Blockchain > In Google Sheets, how to convert [2021-10-08 23:49:37] to a (-6) time zone and look like [10-October

In Google Sheets, how to convert [2021-10-08 23:49:37] to a (-6) time zone and look like [10-October

Time：10-20

This includes

The day difference
Converting 24h to AM/PM
Format: day-month-year, hour:minutes:seconds AM/PM
Note: when double-clicking the original cell it's formatted as text and has (') before the text

CodePudding user response：

try:

=TEXT((A1*1)-"6:00", "dd-mmmm-yyyy, hh:mm:ss am/pm")