TimeValue Type mismatch

[chris01395]

I am trying to adapt some code originally shared with me by @torachan, but really struggling with the column I am using for times;

Can anyone spot anything I am doing wrong? I have added comment next to line in code that appears to be the problem.

FYI column 2 contains date, column 4 a time and 6 a number (minutes)

Please Login or Register  to view this content.

[AlphaFrog]

The issue is the value in column 4 is not recognized as a time value. Without having seen your worksheet, it's difficult to recommend a solution.

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[joeu2004]

[.... deleted by me; essentially the same as AlphaFrog ....]

[chris01395]

Thanks for the interest in my issue, please see attached file,
I also add some comments and screen shots on 'Description of error' sheet to explain how the issue is occuring

[AlphaFrog]

The TimeValue function converts text into a serial time value. The cells in column G are already serial time values. You do not need the TimeValue function.

Controls("TextBox" & i).Text = Format(.Range(sc, i), "hh:mm")

[chris01395]

Thanks AlphaFrog, that solved the issue