To determine shift timing based on a time stamp field

Hi all,

I have an issue with a determing shift timings.

I have a time stamp field QALS-ENTSTEZEIT which has a value like 17:22:29.

Now based on this I have to determine the shifts.

There will be 3 shifts.

shift 1 between 08:00:00 to 16:00:00

shift 2 between 16:00:00 to 00:00:00

shift 3 between 00:00:00 to 08:00:00.

Now the issue is :this statement,

QALS-ENTSTEZEIT BETWEEN '00:00:01' AND '08:00:00'.

do not triggered.

Please suggest some solution.

Thanks and Regards

Nazmul