I want to get the correct information according to the following table
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD]Albert[/TD]
[TD]00:20[/TD]
[TD]5*00:20[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD]Bertie[/TD]
[TD]00:45[/TD]
[TD]5*00:45[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD]Charles[/TD]
[TD]00:25[/TD]
[TD]5*00:25[/TD]
[/TR]
</tbody>[/TABLE]
Without using VBA How can I get the information on Column C?
I don't want to get 5*0,0138888888888889 neither 01:40. I want to get 5*00:20.
Thanks
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD]Albert[/TD]
[TD]00:20[/TD]
[TD]5*00:20[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD]Bertie[/TD]
[TD]00:45[/TD]
[TD]5*00:45[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD]Charles[/TD]
[TD]00:25[/TD]
[TD]5*00:25[/TD]
[/TR]
</tbody>[/TABLE]
Without using VBA How can I get the information on Column C?
I don't want to get 5*0,0138888888888889 neither 01:40. I want to get 5*00:20.
Thanks