K
King
Hi
I have a report with the following fields: Employee number, Client ID,
Meeting Date, Meeting Start Time and Meeting End Time. I counted the
number of hours using the function Minutes:
DateDiff("n",[MeetStartTime],[MeetEndTime]). It works fine but with a
slight problem. When an employee meets two Clients on the same day at
the same time , it records two as separate hours and this creates
excess hours spent by the employee.
Following is the sample report of hours spent by an employee E1.
Client ID Program ID Date Start Time End
time Duration
1 ABC 07/10/2006 10:00 AM
11:00 AM 1:00
2 ABC 07/10/2006 10:00 AM
11:00 AM 1:00
3 ABC 07/10/2006 11:00 AM
12:00 AM 1:00
The first two meetings are group meetings i.e employee has spent has
the same time with two clients and it should record as one transaction
i.e 1 hour but it records as 2 labor hours.
Please help me
I have a report with the following fields: Employee number, Client ID,
Meeting Date, Meeting Start Time and Meeting End Time. I counted the
number of hours using the function Minutes:
DateDiff("n",[MeetStartTime],[MeetEndTime]). It works fine but with a
slight problem. When an employee meets two Clients on the same day at
the same time , it records two as separate hours and this creates
excess hours spent by the employee.
Following is the sample report of hours spent by an employee E1.
Client ID Program ID Date Start Time End
time Duration
1 ABC 07/10/2006 10:00 AM
11:00 AM 1:00
2 ABC 07/10/2006 10:00 AM
11:00 AM 1:00
3 ABC 07/10/2006 11:00 AM
12:00 AM 1:00
The first two meetings are group meetings i.e employee has spent has
the same time with two clients and it should record as one transaction
i.e 1 hour but it records as 2 labor hours.
Please help me