Hello Developers, I have an excel where employees shift time and log in time is present in two column so i want details that today who is not log in on his shift time(who comes late at office) [image]

How to compare between times in excel

Srini84 (Srinivas Kadamati) August 13, 2020, 7:15am 2

Check as below

Attached workflow for your reference

Mark as solution if this helps

Thanks

I need to subtract column A and B by using for each loop

Topic		Replies	Views
Based on Time bot write Present or Absent Studio studio , question , activities_panel	13	1481	March 19, 2022
How to compare two excels data and find the matching rows and avoid seconds in time column Activities excel , activities , question	21	109	November 18, 2024
Compare Time column in two different excels and get matching data Activities excel , activities , question	6	55	November 9, 2024
Comparing Two Times In Excel Studio studio , question , activities_panel	3	784	January 29, 2022
TimeDiff Calculation Studio uiautomation	4	402	May 28, 2023