How to Split 24 hrs into 4 intervals of each 6 hrs

Hello,

in a excel i have n number of records for every record I have a timestamp starts from 00:00:00 to 23:59:00( for one day records)

Now I’m reading excel and storing data into variable in uipath.

Now I have divide all records into 4 sets based time column like
first set 00:00:00 to 05:59:00
2nd set 06:00:00 to 11:59:00
3rd set 12:00:00 t0 17:59:00
4th set 18:00:00 to 23:59:00

Can anyone please help me How i can achieve this?? Thanks in advance.!!

You can use Filter Data Table Activity or Assign Activity with DataTable.Select(filterCondition).

What is the data type of this time column in the Data Table?
In order to filter work, the data type should not be string.

Please find the attached flow
Time_Compare.zip (21.7 KB)

Let me check.

Meanwhile can you check the below thread -