replacing a char with another char

[aheavy95]

Hi all,

couldnt find a solution that helped me.

In the following expression :

left(num(sum(TotalPause)*24,'0.00'),1) &':'&
round(right(num(sum(TotalPause)*24,'0.00'),2) *60/100,'0.01')

I need to replace the '.' with a ':'  

so for example the 3rd value will look like: 

3:51:00

what is a proper solution? 

thanks 

Alon

I need to replace 

[BrunPierre]

Like this perhaps

Time(Time#(left(num(sum(Value)*24,'0.00'),1) &':'&round(right(num(sum(Value)*24,'0.00'),2) *60/100,'0.01'),'hh:mm.ss'),'hh:mm:ss')

[MarcoWedel]

So you are trying to sum intervals and display the result in a specific format?