Time Format

[Nadiyah]

Hello everone 

I'm facing an issue with the time format, the current format for the time is 06.00.00 however I can not apply any calculation in this format 

Is there a way to convert this format 06.00.00 to 06:00:00?

appreciate your support 

[BrunPierre]

Hi

You could try this

Time(Time#('06.00.00' ,'hh.mm.ss'),'hh:mm:ss')

[Bill_Britt]

Hi,

To all on to BrunPierrie post, which is correct for a single value.  If you have a field you want to convert you would use Time(Time#('Fieldname' ,'hh.mm.ss'),'hh:mm:ss')