Upload Attendance File
Cleaning Rules:
- Before 12:00 PM: keep only the earliest AM Time In.
- 12:00 PM to 1:00 PM: keep AM Out and PM In if both are present.
- After 1:00 PM: keep first PM In if no lunch PM In exists.
- Beyond 5:30 PM: keep only the latest PM Time Out.
- Undertime cases are allowed by keeping the latest valid remaining out log.
- Target output is maximum 4 logs per employee per day.
No database required. The file is processed directly during upload and downloaded immediately as a corrected DAT file.