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

user_14040614 0
Viewed 42

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
spreadsheet google-sheets timezone string-formatting datetime
1 Answers

try:

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

enter image description here

user_56326290
Related