I have a User form to capture the time certain jobs take.
The userform calls out the current time and then displays a timer , once the Stop is hit it takes the data and places it into Sheet 2 , from here it copies the data and places it into another excel sheet.
The issue is The time keeps converting in # and cannot be changed back to time. Not sure if this is the Userform or the sheets.
The strange thing is The manual Button works fine , But the Auto button converts it??
I have attached both sheets,
Any help on the issue would be great
Cheers
Bookmarks