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
Bookmarks