help identify the string contents time

[ks1102]

Hi. Expects
Looking for help to identify the string contents time is greater than 12:00 ?

Do formulas or macros can suitable for loop on COL” C which is the said string” then COL” F” = ( if greater than 12:00 = AF) otherwise = AM .
(LORRY@10/25 09:03 (286768-VONDOR)

Thanks for help

[nilem]

Hi ks1102
Can you show an example of a file with your data

[ks1102]

COL C Data is too many like that !

LORRY@10/25 08:44 (374387-VONDOR)
LORRY@10/25 08:45 (374387-VONDOR)
LORRY@10/25 08:50 (374387-VONDOR)
LORRY@10/25 09:05 (374387-VONDOR)
LORRY@10/25 09:12 (591031-VONDOR)
LORRY@10/25 09:13 (510392-VONDOR)
LORRY@10/25 09:03 (286768-VONDOR)
LORRY@10/25 09:09 (358716-VONDOR)
LORRY@10/25 09:30 (868376-VONDOR)
LORRY@10/25 08:32 (614000-VONDOR)
LORRY@10/25 09:16 (614000-VONDOR)
LORRY@10/25 09:01 (614000-VONDOR)
LORRY@10/25 08:33 (614000-VONDOR)
LORRY@10/25 08:58 (614000-VONDOR)
LORRY@10/25 13:23 (614000-VONDOR)
LORRY@10/25 08:59 (614000-VONDOR)
LORRY@10/25 08:58 (614000-VONDOR)
LORRY@10/25 08:29 (614000-VONDOR)

[zbor]

Here, try this:

Please Login or Register  to view this content.

[ks1102]

Dear Zbor ...
formulas work perfectly
thxx