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!!!

[Anil_Babu_Samineni]

don't use Pick match here, I know your intention. Should be this?

If(Match([login time], '6:30','16:30','22:30'), [login time])

[arvind_patil]

Hi Antony,

try to use calculate Dimension in List  box As Follow:

=If(WildMatch([login time],'6:30:00','16:30:00','22:30:00'),[login time])

Thanks,

Arvind Patil

[antonybi]

Still it is not showing anything I have tried the same as you suggested.

PFA for your reference!!

[Anil_Babu_Samineni]

Looks like showing?

[Anil_Babu_Samineni]

Or this?

=If(Match([login time], '6:30','16:30','22:30'), TimeStamp([login time]))

[antonybi]

No it is not showing anything.

[Anil_Babu_Samineni]

I just opened your application? Check my replies with screenshots.

[antonybi]

Both expressions I have tried but it is still not showing anything.

what's wrong with this??

Can you do it in my application which shared in the below.

[Anil_Babu_Samineni]

May be share your image, Where it is not working for you