i have two kind of time formats:
00:01:10 wich is hh:mm:ss and 01:10 wich is mm:ss.
i need to convert the second format to hh:mm:ss
how can i do this?
i've tried with timestamp# (date,'hh:mm:ss') and whit Date#(date,'hh:mm:ss) but it didn't do what i need.
thanks for your help!
Try using the alt() function in combination with interval# / interval functions:
interval(alt(interval#(Duration,'hh:mm:ss'),interval#(Duration,'mm:ss')),'hh:mm:ss') as NewField,
Hope this helps,
thanks for your answer it really helped me.
Retrieving data ...