B
b5917bts
I have an import table tha has employee hourly clock rings. My problem is
that an employee may clock in late one night on one date but continue to the
next day with another Date. How can I make an application that will change:
Test1
Name Day Operation Time
RICHIE CG 8-Jul-06 BT 4
RICHIE CG 8-Jul-06 ET 10.25
RICHIE CG 10-Jul-06 BT 22.25
RICHIE CG 11-Jul-06 OL 0.5
RICHIE CG 11-Jul-06 IL 1.5
RICHIE CG 11-Jul-06 ET 7
RICHIE CG 12-Jul-06 BT 3
RICHIE CG 12-Jul-06 OL 10.16
RICHIE CG 12-Jul-06 IL 10.86
RICHIE CG 12-Jul-06 ET 13.62
RICHIE CG 13-Jul-06 BT 20
RICHIE CG 13-Jul-06 OL 22.5
RICHIE CG 14-Jul-06 IL 0.5
RICHIE CG 14-Jul-06 ET 6
To look like:
Test1 Results
Name Day BT OL IL ET
RICHIE CG 08-Jul-06 4 10.25
RICHIE CG 10-Jul-06 22.25 0.5 1.5 7
RICHIE CG 12-Jul-06 3 10.16 10.86 13.62
RICHIE CG 13-Jul-06 20 22.5 0.5 6
I appreciate any help from anyone out there.
TY
that an employee may clock in late one night on one date but continue to the
next day with another Date. How can I make an application that will change:
Test1
Name Day Operation Time
RICHIE CG 8-Jul-06 BT 4
RICHIE CG 8-Jul-06 ET 10.25
RICHIE CG 10-Jul-06 BT 22.25
RICHIE CG 11-Jul-06 OL 0.5
RICHIE CG 11-Jul-06 IL 1.5
RICHIE CG 11-Jul-06 ET 7
RICHIE CG 12-Jul-06 BT 3
RICHIE CG 12-Jul-06 OL 10.16
RICHIE CG 12-Jul-06 IL 10.86
RICHIE CG 12-Jul-06 ET 13.62
RICHIE CG 13-Jul-06 BT 20
RICHIE CG 13-Jul-06 OL 22.5
RICHIE CG 14-Jul-06 IL 0.5
RICHIE CG 14-Jul-06 ET 6
To look like:
Test1 Results
Name Day BT OL IL ET
RICHIE CG 08-Jul-06 4 10.25
RICHIE CG 10-Jul-06 22.25 0.5 1.5 7
RICHIE CG 12-Jul-06 3 10.16 10.86 13.62
RICHIE CG 13-Jul-06 20 22.5 0.5 6
I appreciate any help from anyone out there.
TY