Filter excel sheet based on total hours in a Week

Question

I have a excel sheet where I have 3 cols. The first col is the name, second is hours and third is date.

Col1      Col2       Col3

A            2hr        1feb

B            4hr        1feb

C            3hr        1feb

D            2hr        1feb

A            3hr        2feb

B            2hr        2feb

D            3hr        2feb

A            2hr        2feb

C            3hr        2feb

Now I want to filter this excel sheet based on the date and hour. So, I want to check that if a person exceeds 10hrs in a week (e.g. from 1-7feb, 8-14feb….)

aatalai · Answer

@Asad1 have you set your number to double

Asad1 · Answer

Hello @aatalai

I tried your workflow but the formula tool for the date format is showing an error: "Error: Formula (5): Parse Error at char(0): Wrong number of parameters for the function "CEIL". (Expression #2)"

Can you you please help with this, thanks.

Manoj_k · Answer

hi @Asad1 i have attached the workflow, it is almost same to the output you wanted

flag.yxmd