Show only distinct time values in list box

[#1]

Hi,

I am having a date field named 'CalenderDate' which is in 'DD/MM/YYYY HH:MM:SSS' format. I Want to only show 'HH' part of it in list box. The data is similar to below

01/01/2012 10:15:123

01/01/2012 10:16:876

01/01/2012 23:11:111

so there are multiple records for one date each having different time stamp.

To show only 'HH' part in list box, I am using formula as =Date(CalenderDate, 'HH); it is returning HH part, but it is duplicating.

As you can see there are two records having time stamp 10:15 and 10:16; so it is showing 10 two times in list box.

I want to display it only once. Does anyone knows how to achive this?

Thanks in advance.

-

Raj Patil

[MarcoWedel]

3 posts dating from 2012,

7 from 2016

(8 actually if I hit "Add reply")

I guess it's ok now to continue this thread ...

[sunny_talwar]

Math works, but the only thing to keep in mind is that we probably won't hear back from the OP.

p.s. it would be funny if he comes back and mark one of the new responses as correct