Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

TIME & ATTENDANCE

Status
Not open for further replies.
BALLYMOUNT

BALLYMOUNT

IS-IT--Management
Mar 13, 2002
6
IE
Hi ,
I've got a database of staff clock-in / clock out times. What I want to do is report on the number of staff in work each hour of the day. If a person is in more than 35 minutes out of the hour then they are regarded as being in for that whole hour.

Database example;

Fields: StaffNumber,Swipe1,Swipe2,Swipe3,Swipe4
Example Data: 088 ,9:05 ,11:30, 12:01, 18:00
098 ,9:10 ,10:20, 10:45, 12:01
187 ,8:55 ,11:15, 11:45, 14:00
etc,etc.

The outputed report should show the following;
Example Layout

Time: NumberOfStaffInWork
9-10 3
10-11 2
11-12 2
12-13 2
13-14 2
14-15 2
15-16 1
16-17 1
17-18 1
18-19 0

etc,etc .


Any ideas on the best approach ?



 
Status
Not open for further replies.

Similar threads

POrlowski
  • Locked
  • Question
Calculating Sick Time
Replies
7
Views
531
POrlowski
POrlowski
nerdygirlgear
  • Locked
  • Question
Limit sub report records to a time range on main report 1
Replies
1
Views
218
hilfy
hilfy
GCL2007
  • Locked
  • Question
Date fields coming into Crystal as Date/Time 1
Replies
2
Views
269
GCL2007
GCL2007
NKOS13
  • Locked
  • Question
How do l convert audit time as per the format
Replies
1
Views
214
dgillz
dgillz
sfullergs
  • Locked
  • Question
Select records by time frame
Replies
1
Views
188
lbass
lbass

Part and Inventory Search

Sponsor

Back
Top