Stack Overflow
Stack Overflow

Questions tagged [time-and-attendance]

Time and Attendance systems are those that keep track of people's comings and goings. Typically this refers to employees working in a business. However it can also be used in other contexts, such as students attending a class.

Time and attendance systems are those that keep track of people's comings and goings. Typically this refers to employees working in a business. However it can also be used in other contexts, such as students attending a class.

There are a whole range of technical problems involved with this category of business systems, such as:

  • Date/Time Set and Interval mathematics
  • Nuances of date and time in the real world
  • Pattern recognition in event streams
  • Business rules engines
  • And much more.

Time and Attendance systems also tend to overlap (Venn diagram style) with the following:

  • Payroll Systems
  • Scheduling Systems
  • Access Control Systems
  • Employee Benefits Systems

The broader category of these systems is known as Workforce Management.

StackOverflow is not the place to discuss commercial Time and Attendance products. However, there are many programming problems associated with building these products, or integrating with them, that may be appropriate if phrased properly.

Also appropriate are generalized questions that would be useful if building an in-house Time and Attendance system.

165 questions
0
votes
2 answers

Limiting the time in and time out in a day in VB.NET?

I have developed a time monitoring system using fingerprint where the employee will scan his/her finger then it will record the time in and time out. But my problem is logging in and logging out by the employee is unlimited. Is there a solution…
user2059513
0
votes
1 answer

logical method to get the total time of night shift differential in vb.net

need help... i have scenario.. note: i want a logical method to solve and get the time differential of night schedule. for attendance monitoring. first, the night differential schedule (10:00:00PM - 06:00:00AM) second, my regular attendance shift…
Deorwin Bensurto
  • 13
  • 9
0
votes
1 answer

Stored procedure to update one column with different values

I'm having difficulties creating a stored procedure that would update rows based on employeeno, checktime and id. Here is my table: I am creating an employee attendance system. Basically we have biometrics finger scanning device to track time and…
Dhenn
  • 295
  • 2
  • 7
  • 27
0
votes
0 answers

How would I appropriately design a ViewModel to edit attendance for different Courses with varying amounts of days of attendance?

I have models for Students, Courses, Enrollment, and Attendance. Each course has a different number of days of attendance and I need to be able to edit attendance for those days. I use the following models: public class Student { public int…
Ecnalyr
  • 5,792
  • 5
  • 43
  • 89
-1
votes
1 answer

PostgreSQL Attendance and night shift

i have following table: dt type 2022-09-12 21:36:26 WORK_START 2022-09-13 02:00:00 BREAK_START 2022-09-20 06:00:00 WORK_START 2022-09-20 10:00:00 BREAK_START 2022-09-20 10:27:00 BREAK_END 2022-09-20 13:00:00 WORK_END 2022-09-13…
Jorns 90
  • 1
  • 1
  • 2
-1
votes
1 answer

Access - Excel(VBA) - Type Mismatch

We're trying to load data from Access Database using VBA to Excel. But our code doesn't work fine. SQL1 = "SELECT Name " & _ SQL1 = SQL1 & "FROM February" & _ SQL1 = SQL1 & "WHERE Gender = 'F'" & _ SQL1 = SQL1 & "ORDER BY Name" Set rs1 =…
Chedrick Rowy
  • 7
  • 1
-1
votes
1 answer

i want to a increase date in my datagridview header

I am working on attendance software I am facing an issue that is I want to increase date on every header. Here you can see my datagridview : https://i.stack.imgur.com/cXm2u.jpg Actually, I wanna show whole month attendance and I wanna get dates and…
digisoft
  • 15
  • 7
-1
votes
1 answer

Fetching attendance from multiple timestamp and calculating working hours of each employee each day of month

I have a database where I have multiple timestamp of each employ for each day.I want to calculate working hours from min and max timestamp of EACH DAY of the MONTH. Something like this: idx=primary key idx id date 1 8080 2018-09-25…
Akib Javed
  • 1
  • 2
-1
votes
1 answer

Count and insert with condition Codeigniter

I have a form that i need to fill in order to fill out an allowance table. The allowance table contains Employee Code, Employee Name, Period of time, and days attended. The form only contains employee code, employee name, and period of time. So the…
Team
  • 55
  • 9
-1
votes
1 answer

Accessing fingerprint template from fingerprint sensor(R305)

Hello i have a project to implement fingerprint attendance system for my college. I have a problem that i want to access fingerprint template from sensor R305 and store it in a database. And when user place his finger print on reader than data must…
Akshar Tank
  • 53
  • 3
-1
votes
1 answer

Attendance of each student

I am trying to generate attendance of each student on a monthly basis. My approach is this way.. May be wrong but I am trying this way. I have an attendance table which has fields like branch, semester, section, and the attendance_status(0 or 1)…
Havish
  • 33
  • 7
-1
votes
2 answers

List of Employees who are not in the list one day before and one day after weekend

I need list of those employees who are absent one day before and one day after weekend in a week......like if some is absent in Friday and present on Monday should not be included in the list
IbrahimSediq
  • 1
  • 1
-1
votes
1 answer

SQL SERVER Total work hours calculation with Multiple IN and OUT and its details

I have a Table Name as EmpLog EmpLog Table ID EmpId Status ActionDateTime Id - Primary Key EmpID - Employee code. // example N100 ,N101, N200 Status - IN / OUT ActionDateTime - Time with Date. Exact occurrence of IN or OUT log entry. Click…
Nehru
  • 11
  • 3
-1
votes
2 answers

How to override the default calendar date and create a custom day for a company?

In my office, I am creating an HR website for employees. There is a module to calculate attendance details, working hours etc.. So if an employee came to office in the morning and if he left the office at about 8PM in the night its OK. Because both…
Prageeth Liyanage
  • 1,612
  • 2
  • 19
  • 41
-1
votes
1 answer

simple attendance system with radio button

I am making a simple attendance class system I have this php code with radio buttons here.. now i put it in a table I can only choose one radio button on the entire table instead of one radio button per registered…
Rhatz
  • 33
  • 1
  • 4
1 2 3
…
10
11