Kristen_cancerkiller
Member
I have created a userform which requires an employee to enter depart and return time from travel. I am currently using the following code to move the field to my database, however, I would like to ensure that the time is formatted as "hh:mm" so it will return responses such as 16:24 in my database field. I know that the format I want is as entered above (hh:mm) but I am unsure where to insert this into the following code. I would greatly appreciate it if someone would be willing and able to help me with this.
Code:
Sheets("Travel Expense Voucher").Range("Data_Start").Offset(TargetRow, 25).Value = txtDepartTime 'departure time