converting time format

[BenGielen]

Hello together,

i have an question to convert a duration/time format.

my data is for example: 6,35 (these are hours) (6,35h availability)

i need to convert this 6,35 to 'hh:mm:ss' like this -> 06:35:00.

how can i do this in the loading script. 

thank you very much for your support. 

Ben

[Taoufiq_Zarra]

@BenGielen 

May be this :

=interval((subfield(Field,'.',1)*3600+subfield(Field,'.',2)*60)/86400, 'hh:mm:ss') 

output for 6.35

[rwunderlich · Accepted solution]

A small tweak would be to use interval#()

interval(
interval#(subfield(Field, ',', 1), 'h') +  interval#(subfield(Field, ',', 2), 'm')
,'hh:mm:ss')

-Rob