Apr 02 2022 01:40 PM
Apr 02 2022 02:52 PM
You may transform text to time with TIMEVALUE(), e.g.
=TIMEVALUE("14:00")
and apply to the result any desired time format
Apr 02 2022 03:04 PM
Apr 02 2022 03:04 PM
In addition, you may consider Power Query option where such transformation are doing practically natively, like
The latest column is transforming datetime from UTC-5 into my local time zone.
Apr 02 2022 03:07 PM