Excel Complex Validation - Need inputs

Help
, ,
#1

Hi Guys,
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

Thanks

#2

Hello @sybasha!

It seems that you have trouble getting an answer to your question in the first 24 hours.
Let us give you a few hints and helpful links.

First, make sure you browsed through our Forum FAQ Beginner’s Guide. It will teach you what should be included in your topic.

You can check out some of our resources directly, see below:

  1. Always search first. It is the best way to quickly find your answer. Check out the image icon for that.
    Clicking the options button will let you set more specific topic search filters, i.e. only the ones with a solution.

  2. Topic that contains most common solutions with example project files can be found here.

  3. Read our official documentation where you can find a lot of information and instructions about each of our products:

  4. Watch the videos on our official YouTube channel for more visual tutorials.

  5. Meet us and our users on our Community Slack and ask your question there.

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!

Cheers from your friendly
Forum_Staff

#3

Hi @sybasha,
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.

Please check out this post:

1 Like
#4

yes i did.

#5

Hi @sybasha I am confused about the DAILY TOTAL ? And about the second condition

Also can u elaborate ur query clearly with an Excel file?

#6

daily total is nothing by the hours between start time and end time.Sample Fourm.xlsx (9.5 KB)

The sample excel as in attached