Quote Originally Posted by alvin-chung View Post
Hi benno, formatting suggested by shg works for me.
Could you share more details as in how it doesn't worked for you?

This are the steps that I've taken as suggested by shg:
1. A1=0:01:20.555
A2=01:00:00.000
A3=0:02:01.111
2. Create formula in column B to reference column A, i.e. B1=A1, B2=A2, B3=A3
3. Format column B with custom type [s].00


_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved

Alvin
Hi alvin-chung,

Ive included some screenshots of the steps that you and shg gave me and the outcome, as I don't understand why its not working...
1.png2.jpg3.jpg4.jpg

As you can see the values in B1, B2 & B3 are wrong...

Thanks