DateTime without seconds

bouhme
New Member

I have a column with the type DateTime where I will store day and time of meetings. For the time it is enough to have hour and minutes. But DateTime also gives me seconds . So how can I change this?

0 2 2,194
2 REPLIES 2

Hi @bouhme, thereโ€™s actually a setting in the Column Definition of that column that lets you disable seconds.
Click the pencil icon to open the Column Definition 2X_5_5a3dee031217e62d479f102f472c9b879fe4a52e.png

HI Peter, that`s great it works. Im searching in the help in in google sheets but canยดt find it.
Thank you very much.

Top Labels in this Space