How to convert Time To Seconds

Hi Thennarasu_R ,

According to your description, here is my solution.

You can use Duration.From , Duration.TotalHours and Duration.TotalSeconds in Power Query.

Create custom columns.

1, return the duration between two times.

= Duration.From([End time]-[Start time])

2, return Overall Seconds

= Duration.TotalSeconds([duration])

3, return Overall Hours

= Duration.TotalHours([duration])

Final output:

Best Regards,
Community Support Team _ xiaosun

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.