update time based on condition

Question

Hi

I want to update the start and end time based on the condition

For type column  - work start time should be whatever it is there but for end we need to take start time from lunch

And then lunch start and end will remain same only

Then for last row start time end time from lunch and end time what ever we have in end.

Little bit confusing that's why adding both input and output files.

Input Sample.xlsx

Output Sample file.xlsx

Emmanuel_G · Answer

@sgaryali

Find in attachement the solution to this issue with a different method.

Let me know if the solution is ok for you. 🙂

Update time based on condition.yxmd

grazitti_sapna · Answer

Hi @sgaryali , my solution would be something similar to what @Christina_H  has provided. Please find the workflow for same.

Lunch.yxmd

Christina_H · Answer

I think this is what you want

Lunchtime.yxmd