Capturing time through Excel Macro

Hello,

I am trying to capture the timings of my team for various activities like break, meeting, working hours, login & logout timings etc...I have create a macro and its working fine upto the limit. But I have few more issues and some more requirements are there..

I am using application.ontime code to capture time for these various activities.its working fine. when i try to close the excel file it again reopens automatically. It closed when i close entire excel window. how do i avoid this issue.

And one more thing is I have different shift timings are involved. And I want to capture only once the login & log out timings for the day. please tell me how to do that...
I am using excel form as front end & Ms access as backend to store the data.

Thanks in Advance...!