Convert Text to Time

Hi and welcome to the forum

This will work for most of your data but not all.

Highlight your range (for instance E3:F852) and press CTRL H (Find/Replace)
Find :00:
Replace 00:

If you look at your data, you will see that some is left justified and some right. The right justified is (generally) numeric and left is (generally) text, so it will be easy to see which cells still need adjusting. E23 for instance will need to be manually adjusted - unless you have a lot of cells that you can use :23: on

Let me know how you make out?

You may try this code to see if this helps......

Sub replace()
Dim cell As Range
Application.ScreenUpdating = False
For Each cell In ActiveSheet.UsedRange
    cell.Select
    If Left(cell, 1) = ":" Then
    cell = 0 & cell
    End If
Next cell
Application.ScreenUpdating = True
End Sub

To apply the code on the sheet...

Press Alt+F11 to open VBA Editor --> Insert --> Module --> Paste the above code in the code window --> Press F9 to run the code --> Save your workbook as Excel Macro-Enabled Workbook.

You're welcome. Thanks for the feedback.
If that takes care of your question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.
Moreover you may also click on * (star) to Add Reputation to those who have put their time and efforts to help you in this forum. This is another way to say thanks to them.