Lets take CELL `A1`

contains `1500`

. To achieve the result, there are many ways to do.

Lets go with one-by-one.

Now you can do this way, to achieve one type of result:-

```
=TEXT(REPLACE(TEXT(A1,"##-##"),3,1,":"),"h:mm AM/PM")
```

**OR**

```
=TEXT(LEFT(A1,LEN(A1)-2)&":"&RIGHT(A1,2), "h:mm AM/PM")
```

**OR**

```
=TIME(LEFT(A1,2),RIGHT(A1,2),0)
```

## OUTPUT:

```
3:00 PM
```

If you want only adding a colon in between, then do this way:-

```
=LEFT(A1,LEN(A1)-2)&":"&RIGHT(A1,2)
```

**OR**

```
=TEXT(LEFT(A1,LEN(A1)-2)&":"&RIGHT(A1,2), "h:mm")
```

**OR**

```
=TEXT(A1,"##\:##")
```

## OUTPUT 2:

```
15:00
```