Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
A small tweak would be to use interval#()
interval(
interval#(subfield(Field, ',', 1), 'h') + interval#(subfield(Field, ',', 2), 'm')
,'hh:mm:ss')
-Rob
May be this :
=interval((subfield(Field,'.',1)*3600+subfield(Field,'.',2)*60)/86400, 'hh:mm:ss')
output for 6.35
A small tweak would be to use interval#()
interval(
interval#(subfield(Field, ',', 1), 'h') + interval#(subfield(Field, ',', 2), 'm')
,'hh:mm:ss')
-Rob