Convert Time (hh:mm:ss) to Duration (hh:mm:ss)

[Anonymous]

Hello,

Is there a method to convert Time format to Duration.

I have tried converting data type but results in a data format error.

See attached images for info.

Thanks,

Query

[v-chuncz-msft · Accepted solution]

@Anonymous ,

You may try the custom column below.

#duration(0, Time.Hour([Column1]), Time.Minute([Column1]), Time.Second([Column1]))