Original regional settings culture: ru-UA
Date-Time value setup in cell: “16.09.2019 18:50:00”.
Build-in Number style setup in cell: 22.
Result cell’s display value: “16.09.2019 18:50”
After changing user’s regional settings for short time and short date format to following:
Short time format: “hh:mm tt” (was HH:mm).
Short date format: “dd.MM.yy” (was dd.MM.yyyy).
and building the save Excel file with the same Number style 22 we have display value “16.09.19 18:50”.
So as we see, date part is changed as required: year is now in two digits.
But time part still the same but it should be AM\PM format, i.e. “6:50 PM”.