Time formatting - AM/PM && 24 HOURS

Hi,

I know there had been few topics here in the Community, dedicated to time formatting and specifically to AM/PM vs 24 H view format.
However, before posting here I ensured that my underlying spreadsheet (SS settings) and my testing phone are both in English UK date/time format/locale. Yet, surprisingly enough, I have the same issue where my times are with AM/PM tags.
Here is the view in table format:
2X_e_eb17731268272e49f303600ede8ff23edd9d926b.png
However, in the Details/Form view of the same table, the times look ok:

Thus it seems to be that only TABLE view is wrong.
Not sure what else to check to make things right.
The colums in question have DateTime Type.
Appreciate any hint on this,
thank you,

Alex

Solved Solved
0 5 2,070
1 ACCEPTED SOLUTION

Yes. It sounds to me like there is some kind of bug involved. Concatenating may be a workaround until the bug gets straightened out. Good luck!

View solution in original post

5 REPLIES 5
Top Labels in this Space