object_doubt

[antonybi]

Hi All,

I have a list box and it contains shift times But here I don't want to show all the shifts.

I want to display only particular times like 6:30:00 AM, 4:30:00 PM, 10:30:00 PM

I have tried with combination of pick and match.

=Time(Pick(Match([login time],'6:30','16:30','22:30'),'6:30','16:30','22:30'),'hh:mm:ss TT')

but it is not working.

any suggestions will be appreciated.

Thanks in advance!!!

[antonybi]

I think it is something wrong in my application can you check it out?

[antonybi]

PFB for your reference

[Anil_Babu_Samineni]

Expression correct only, and in your script there is not good connection. Could be the reason?

[effinty2112 · Accepted solution]

Hi Antony,

Try:

=Aggr(if(Match([login time],'6:30','16:30','22:30'),Time([login time])),[login time])

as the expression in a listbox.

Cheers

Andrew

[antonybi]

No. Now I configured correct connect even though I am getting same issue.

I don't  understand whats really wrong with this?

[antonybi]

Hey thank you so much it worked.