Need Help Multiplying and Adding digits from the same Cell in Excel

Dear All,

I am trying to find a solution to simplify a complicated work I deal with at times that takes me hours to perform it manually. I am a starter in MS Excel and I deal with mostly simple MS Excel operations every day at work. I appreciate any solution provided to me on the below Problem I have

ex. 2 19:12:54
I need to Multiply the 2 with 24 and then SUM it with 19 which is after a space in the Cell. So, the result should look like 67:12:54

At times, I come across a situation where I nearly see 200 cells of random numbers in the column where I need to perform this activity manually.

Please help!!