S
stag246
I am having trouble figuring out what to do with this here…
We have a web-based form where people enter times for employees that take
care of consumers. Most employees have more then one consumer so they have to
fill out more then one time sheet to be entered into the web-based form but
there are some employees that are putting a time say like below that they
would traveling from 2:15 til 3:00 and be at a Consumer’s place from 2:45 til
3:15 which means that they would be in two places at once. Would there be a
way I can set up a report or something that would verify that they were not
double charging the company?
time checking
id date | consumerNO |fromTime | toTime | earnCode
1 3/1/2004 12 2:00 pm 2:15 pm Train
1 3/1/2004 12 2:15pm 3:00 pm Trvl
1 3/1/2004 14 2:45 pm 3:15pm Con
1 3/1/2004 14 3:30 pm 3:45 pm Train
1 3/1/2004 667 4:00 pm 4:30pm Trvl
Thanks,
Jeremy
We have a web-based form where people enter times for employees that take
care of consumers. Most employees have more then one consumer so they have to
fill out more then one time sheet to be entered into the web-based form but
there are some employees that are putting a time say like below that they
would traveling from 2:15 til 3:00 and be at a Consumer’s place from 2:45 til
3:15 which means that they would be in two places at once. Would there be a
way I can set up a report or something that would verify that they were not
double charging the company?
time checking
id date | consumerNO |fromTime | toTime | earnCode
1 3/1/2004 12 2:00 pm 2:15 pm Train
1 3/1/2004 12 2:15pm 3:00 pm Trvl
1 3/1/2004 14 2:45 pm 3:15pm Con
1 3/1/2004 14 3:30 pm 3:45 pm Train
1 3/1/2004 667 4:00 pm 4:30pm Trvl
Thanks,
Jeremy