Attendance record-In and Out issue

[RAKESH1986]

Hi All,

pls help me to solve this issue. 

I have the below-listed attendance records of the user. And I need to calculate the hours spent in the office. For this, I took the lowest time as in time and the highest time as out time, by this way it worked fine but a few records created problems for said calculation.

Few employees worked from 8 am to the next day 1/ 2 am in the morning.  and by this way, my logic failed because it took 1 am as the in time of the employee.

Is it possible to ignore the time which is between 12 am to 5 am? and assign the last out time as 11.59 pm for the previous day.

any other better way to handle it?

pls help .

thanks

[RAKESH1986 · Accepted solution]

apply a filter or add a conditional column to replace values.