Unable to format Time

Eklavya 

Another variant is

=--REPLACE(REPLACE(TEXT(C1,"000000"),LEN(TEXT(C1,"000000"))-1,0,":"),LEN(TEXT(C1,"000000"))-3,0,":")

and apply Time format.