I trying to find out the hours worked and breaks time in between by the condition
For Hours worked:
if Name = Row+1 Name and if Event Date = Row+1 Event date then the math should be if Punch out is greater then Row+1: Punch out - Row-1: Punch In else Row-1: Punch In - row+1: Punch out
if the condition Name = Row+1 Name and if Event Date = Row+1 Event date is not satisfied then if Punch out is greater than punch in then punch out - punch in else punch in - punch out
For Break:
if Name = Row+1 Name and if Event Date = Row+1 Event date then the math should be if Punch out is greater then Row+1: Punch out - Row-1: Punch In else Row-1: Punch In - row+1: Punch out
For Punch out:
if Name = Row+1 Name and if Event Date = Row+1 Event date then the math should be Row+1: Punch out else Punch out
For more clarification I had attached excel with Conditions and sample data.
Expecting workflow 😊
Thanks in advance
