Find left and right of symbol in a time

[ScabbyDog]

So I have

03:01:00

in a cell.

I want to find and return everything left of the 1st ':'

I then want a formula that would return the 2 numbers to the right of the first ':'

For the frst part trying to return everything to the left of the 1st ':' I use

Please Login or Register  to view this content.

but it returns 0.125694444 in this example whereas I want it to reteurn 03.

[karedog]

Maybe :

Please Login or Register  to view this content.

[ScabbyDog]

Perfect! Thanks Karedog.

[karedog]

You are welcome, glad I can help.

Regards