cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
CraigDykes Regular Visitor
Regular Visitor

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

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,

error - Copy.JPG

query.JPGQuerydesktop.JPG

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

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

@CraigDykes ,

 

You may try the custom column below.

#duration(0, Time.Hour([Column1]), Time.Minute([Column1]), Time.Second([Column1]))
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Community Support Team
Community Support Team

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

@CraigDykes ,

 

You may try the custom column below.

#duration(0, Time.Hour([Column1]), Time.Minute([Column1]), Time.Second([Column1]))
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.