Can anyone suggest me how to do this?
i. IF “Category” equals A,B,C
THEN count number of hours based on “Start Time” and “End Time” of each “Date”
ELSE no action needed; go to next transaction
ii. IF “Category” equals A,B,C AND “Resource” DAILY TOTAL (calculated of hours) is less than 6 THEN add this row to a separate excel
iii. IF calculated hours worked is less than 6 per Date AND Resource DID NOT work over 5 consecutive days (“Date” column is present which have only one date)
THEN Resource containing “Overtime” SHOULD NOT exist in the same work order (Wk Order)
ELSE add this to a separate excel
“Category”, “Resource”, “Start Time”, “End Time”,“Date” are columns in the excel
You can check out some of our resources directly, see below:
Always search first. It is the best way to quickly find your answer. Check out the icon for that.
Clicking the options button will let you set more specific topic search filters, i.e. only the ones with a solution.
Topic that contains most common solutions with example project files can be found here.
Read our official documentation where you can find a lot of information and instructions about each of our products:
Hopefully this will let you easily find the solution/information you need. Once you have it, we would be happy if you could share your findings here and mark it as a solution. This will help other users find it in the future.
Thank you for helping us build our UiPath Community!
Have you tried to look on forum for some examples? I know RPA and developing automation is not easy task, but you need to try and we as a community are here to help. But I guess nobody will built automation for you especially without knowing any context and information what have you done so far etc.