I have a userform that has 2 command buttons.

Sign In

Sign Out


And when Sign in is clicked it puts =now() into Cell A1
And when Sign out is clicked it puts = now() into cell A2

And cell A3, calculates the time difference

The one big problem I have is that everytime something is entered both the dates change to now. Is there anyway when Sign In is clicked it can put the =now() formula and save it right at that time, the same for Sign Out.

Thanks
Josh