Forum Discussion
How to convert Time To Seconds
Hi All,
I stuck with one scenarios,
Anyone help this one
I have two columns
One is Start Time=1:22:00
Second is End Time=19:23:00
My need is In Between time Overall Seconds and Hours
Thanks,
Thennarasu R
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 _ xiaosunIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Please see this article on how to best calculate durations.
Calculate and Format Durations in DAX – Hoosier BI
Pat
ppm1
I found it Using MeasuresMeasure =TIME ( 0, 0, 0 )+ DIVIDE ( SUM ( tbl[Sum of Seconds] ) , ( 24 * 60 * 60 ) )
Once Create Measure Change the data type HH:MM:SS.
Thanks,
Thennarasu
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 _ xiaosunIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
