Solved: Change the format of times displayed in a calc dropdown list

[daveymg]

I have a dropdown list source column containing a list of times in the format 08:00, 08:15, 09:00 etc. The column is formatted as Time HH:MM. The target cell for the dropdown list is also formatted as HH:MM. When clicking the dropdown arrow for the target cell, the list of times is shown as 08:00:00, 08:15:00, 09:00:00 etc.

While the selection values are correct, the trailing zeros (seconds) make it visually cluttered. Is there a way to format them out?

[karolus]

Hallo

Use in ⇒ Data ⇒ Validity … Source:

TEXT( source_range; "HH:MM" ) 

[daveymg]

Perfect, thank you.