Hello Banco,

You can set the destination cell format by using the Format statement in VBA. In the example below, A1 has a regular time value. Cell B1 will convert this to the custom format "hh:mm:ss".
Range("B1").Value = Format(Range("A1"), "hh:mm:ss")
Sincerely,
Leith Ross