Sorting a cloumn with dd:mm:hh

W

wifta

Trying to sort a column that was dd/mm/yyyy and have since changed t
dd:mm:hh to display days, hours and minutes. The results are all ove
the place and not in descending or ascending order.

Any ideas?

Cheer
 
B

Bryan Hessey

Dates and times are Whole numbers (dates), a decimal point, and parts of
numbers (fractions) (Time).

What you select is the display format, not what data is held.

The sort as described should sort chronologically on Full date/time,
not on what you see.

To sort on what you see, you need another column as Text,"dd/hh/mm"

Does this explain what you see?

--
 
B

Bryan Hessey

Dates and times are Whole numbers (dates), a decimal point, and parts of
numbers (fractions) (Time).

What you select is the display format, not what data is held.

The sort as described should sort chronologically on Full date/time,
not on what you see.

To sort on what you see, you need another column as Text,"dd/hh/mm"

Does this explain what you see?

--
 
Top