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)
Bookmarks