I am creating a tracking log to track a specific process and I would like to record the elapsed time on a spreadsheet. My intention is to have the txtStartTime field on the userform (frmLog) populate when the user selects the name of the person that does the fingerprinting. The txtEndTime field will populate when the user clicks the cmdLogEntry button. The cmdLogEntry button also writes the data to the excel spreadsheet. Idealy, I would like to calculate and record the elapsed time on the spreadsheet.
Can someone please help with the vba code to accomplish this task? Or, if there is some other way to accomplish the same result, I'm open to suggestions. Here is the code that I have so far for writing the data to the spreadsheet: