removing last 3 characters from [h]:mm:ss

[keith740]

i need to remove the last 2 digits and the : from cells formatted in [h]:mm:ss

examples.. 0:34:00 needs to be 0:34
1:01:01 needs to be 1:01
47:53:00 needs to be 47:53
18:19:00 needs to be 18:19
38:20:00 needs to be 38:20

i been trying use =LEFT(A1,LEN(A1)-3) but shows as decibal no matter how i format

any help is greatly appreciated!

[daffodil11]

=text(A1,"HH:MM")

[acroley1]

Can't you just format as [h]:mm?

[keith740]

was overthinking that wayy too much, was actually trying to accomplish something not possible by this, will make another post on this.