achelletzhe
New Member
- Joined
- May 11, 2014
- Messages
- 1
Hi I am a begginer with excel vba macro, can you help me create a marco that will open a spreadsheet file (employee doorlogs with dates) this file has columns: Name, Doors and Timestamp.
The condition is the user will be prompt to enter the schedule "Month" and the "Time" another condition is to accept the entry log if he is on an "overtime date". It will hide unnecessary logs, not delete. The out must contain "Only" his first doorlog for the start of his shift and the last log out on his shift. Schedule is shifting. can be 8hrs sometimes 12 hrs.
Please help me with this its been weeks and I still cant solve this.
I only manage to delete unnecessary rows base on my specified string value but can't define the schedule. please help me for the code. It is killing me
.
[TABLE="class: grid, width: 743"]
<TBODY>[TR]
[TD]Employee Name</SPAN>
[/TD]
[TD]Doors</SPAN>
[/TD]
[TD]Timestamp</SPAN>
[/TD]
[/TR]
[TR]
[TD]Erwinson M. Francisco</SPAN>
[/TD]
[TD][MNorth] Turnstile 1 Exit</SPAN>
[/TD]
[TD="align: right"]2/27/2014 7:12:08 AM</SPAN>
[/TD]
[/TR]
[TR]
[TD]Erwinson M. Francisco</SPAN>
[/TD]
[TD][MNorth] Turnstile 2 Entry</SPAN>
[/TD]
[TD="align: right"]2/27/2014 4:53:00 AM</SPAN>
[/TD]
[/TR]
[TR]
[TD]Erwinson M. Francisco</SPAN>
[/TD]
[TD][MNorth] Turnstile 2 Exit</SPAN>
[/TD]
[TD="align: right"]2/27/2014 4:45:42 AM</SPAN>
[/TD]
[/TR]
[TR]
[TD]Erwinson M. Francisco</SPAN>
[/TD]
[TD][MNorth] Turnstile 2 Entry</SPAN>
[/TD]
[TD="align: right"]2/27/2014 3:45:05 AM</SPAN>
[/TD]
[/TR]
[TR]
[TD]Erwinson M. Francisco</SPAN>
[/TD]
[TD][MNorth] Turnstile 1 Exit</SPAN>
[/TD]
[TD="align: right"]2/27/2014 3:05:42 AM</SPAN>
[/TD]
[/TR]
[TR]
[TD]Erwinson M. Francisco</SPAN>
[/TD]
[TD][MNorth] Turnstile 1 Entry</SPAN>
[/TD]
[TD="align: right"]2/26/2014 10:03:26 PM</SPAN>
[/TD]
[/TR]
[TR]
[TD]Erwinson M. Francisco</SPAN>
[/TD]
[TD][MNorth] Turnstile 2 Exit</SPAN>
[/TD]
[TD="align: right"]2/26/2014 9:10:13 PM</SPAN>
[/TD]
[/TR]
</TBODY>[/TABLE]
The condition is the user will be prompt to enter the schedule "Month" and the "Time" another condition is to accept the entry log if he is on an "overtime date". It will hide unnecessary logs, not delete. The out must contain "Only" his first doorlog for the start of his shift and the last log out on his shift. Schedule is shifting. can be 8hrs sometimes 12 hrs.
Please help me with this its been weeks and I still cant solve this.


[TABLE="class: grid, width: 743"]
<TBODY>[TR]
[TD]Employee Name</SPAN>
[/TD]
[TD]Doors</SPAN>
[/TD]
[TD]Timestamp</SPAN>
[/TD]
[/TR]
[TR]
[TD]Erwinson M. Francisco</SPAN>
[/TD]
[TD][MNorth] Turnstile 1 Exit</SPAN>
[/TD]
[TD="align: right"]2/27/2014 7:12:08 AM</SPAN>
[/TD]
[/TR]
[TR]
[TD]Erwinson M. Francisco</SPAN>
[/TD]
[TD][MNorth] Turnstile 2 Entry</SPAN>
[/TD]
[TD="align: right"]2/27/2014 4:53:00 AM</SPAN>
[/TD]
[/TR]
[TR]
[TD]Erwinson M. Francisco</SPAN>
[/TD]
[TD][MNorth] Turnstile 2 Exit</SPAN>
[/TD]
[TD="align: right"]2/27/2014 4:45:42 AM</SPAN>
[/TD]
[/TR]
[TR]
[TD]Erwinson M. Francisco</SPAN>
[/TD]
[TD][MNorth] Turnstile 2 Entry</SPAN>
[/TD]
[TD="align: right"]2/27/2014 3:45:05 AM</SPAN>
[/TD]
[/TR]
[TR]
[TD]Erwinson M. Francisco</SPAN>
[/TD]
[TD][MNorth] Turnstile 1 Exit</SPAN>
[/TD]
[TD="align: right"]2/27/2014 3:05:42 AM</SPAN>
[/TD]
[/TR]
[TR]
[TD]Erwinson M. Francisco</SPAN>
[/TD]
[TD][MNorth] Turnstile 1 Entry</SPAN>
[/TD]
[TD="align: right"]2/26/2014 10:03:26 PM</SPAN>
[/TD]
[/TR]
[TR]
[TD]Erwinson M. Francisco</SPAN>
[/TD]
[TD][MNorth] Turnstile 2 Exit</SPAN>
[/TD]
[TD="align: right"]2/26/2014 9:10:13 PM</SPAN>
[/TD]
[/TR]
</TBODY>[/TABLE]