Time format without the Date part formula to VBA solution for entire column

Please see attached workbook.
In column A I have Times. However when you put your cursor on A2 you will see there is also a date part that is not showing.
But because of that I cannot calculate between times with that cell.

Now on another part of this site I already got a formula solution for this.
You will find it in B2 (MOD(A2;1)).
As you can see in B3 that works just fine.

Now I could use VBA to fill an extra column with this formula.
But as there already are a lot of columns I was looking for a solution that converts the column in place.
This is only a sample the entire list if about 6000 rows (so could be performance problems for some solutions)

Hope there is an elegant solution. I heard VBA has also a MOD function but I cannot get it to work.

ps: orgininally the column is column L (for the VBA code that would matter I guess if the code not explicitly refers to a column letter)

Superb Richard
You used INT (was a second solution I got indeed. Int and Mod)
Just had to use For x = 2 to lRow because I have headers.

Work like a charm. Thank you very much.