I'm trying to remove the leading zeros from time. I want my time format to be hh:mm:ss without leading 0. For example: 011:50:35 should just be 11:50:35

Any idea how I can achieve this please.

Thanks in advance.

2

2 Answers

Probably the custom number format of those cells is [hhh]:mm:ss

If that is the case you can change it to:

[h]:mm:ss (no leading zeros)

or

[hh]:mm:ss (one leading zero for hours 0-9 only.

How about the leading number "1"?

I made a brief sample as following. Befor I enter the data, I set the cell format as Text.

I use formula =IF(LEFT(A1,1)="0",MID(A1,2,LEN(A1)-1),A1) to remove the leading 0, keep the data if leading number is not 0.