Time to minutes or remove characters either way will help!!

[toplad]

Hi guys,

Ive spent the last 2 hours trying to solve this problem and I've hit a wall. Any help would be much appreciated!!

I have this number in a cell 00:20:00 i'd like to remove the last three characters :00 iv'e tried using left and right but it doesn't work and outputs some random number and not 00:20 after striping the last 3 characters.

Basically what im trying to solve (just in case there's an easier way) is converting a list like the one below where it sometimes has the odd one with extra 00's in to minutes in the next column so 00:20 would be 20 and so on.

[TABLE="class: cms_table, width: 61"]
<tbody>[TR]
[TD]00:20[/TD]
[/TR]
[TR]
[TD]00:20[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]00:20:00[/TD]
[/TR]
[TR]
[TD]00:30[/TD]
[/TR]
[TR]
[TD]00:20[/TD]
[/TR]
[TR]
[TD]00:30
[/TD]
[/TR]
[TR]
[TD]00:30[/TD]
[/TR]
[TR]
[TD]00:20[/TD]
[/TR]
[TR]
[TD]00:20[/TD]
[/TR]
[TR]
[TD]00:20[/TD]
[/TR]
[TR]
[TD]00:20[/TD]
[/TR]
[TR]
[TD]00:30[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]00:30[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]00:20[/TD]
[/TR]
[TR]
[TD]00:20[/TD]
[/TR]
[TR]
[TD]01:05[/TD]
[/TR]
</tbody>[/TABLE]

 

[Joe4]

Duplicate: https://www.mrexcel.com/forum/excel-questions/1029738-remove-last-3-characters-number.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).