Attendance system
I want the attendance system created, to sort the data in a form from which: Identifiers such as Job ID and name is used as identifier. Then, from the data, sorted and entered in a form or table, there shall be column for sign on/ sign off. From that, the hours worked can be stated and if less than the set shift hours, then the person is marked as late and the hours late are accumulated in the column for deduction. If 24 hours passes without a registered ID registering time, then they shall be marked as absent. Thus the absent days are also accumulated in the attendance system . If someone works two shifts the same day, then they are entered in a form for overtime, with date and location set as well. Maybe this will be a good guide. 1. From the unsorted data, filter and import data 2. Create columns for ID, Name, Date, sign on, sign off time, longitude/latitude. 3. From the created table, then sort the data based on: a. If sign the difference bet