Forum Discussion

yaman123's avatar
yaman123
Post Partisan
4 years ago
Solved

Calculate Duration from date time fields

Hi,    Is there a way to calculate the duration in hours and minutes from a date time field?    e.g From Date is 24/08/2021 04:03 and To Date is 25/08/2021 06:08. The Duration should be 26:05.  ...
General Comment
Need Help
Show and Tell
Tips and Tricks
  • v-zhangti's avatar
    v-zhangti
    4 years ago

    Hi, yaman123 

     

    You can try the following methods.

    1. First convert all intervals to seconds.

    Seconds =
DATEDIFF ( [Start time], [End time], SECOND )

     

    2. Then convert the seconds to hour-minute-second format.

    Duration =
INT ( [Seconds] / 3600 ) & ":"
    & INT ( ( [Seconds] - INT ( [Seconds] / 3600 ) * 3600 ) / 60 ) & ":"
    & [Seconds]
        - INT ( ( [Seconds] - INT ( [Seconds] / 3600 ) * 3600 ) / 60 ) * 60
        - INT ( [Seconds] / 3600 ) * 3600

     

    Best Regards,

    Community Support Team _Charlotte

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

     

yaman123's avatar
yaman123
Post Partisan
4 years ago

Thanks, that does give me the reuslts I want but can it be formatted to Time so I can take the Average Time? 

v-zhangti's avatar
v-zhangti
Community Support
4 years ago

Hi, yaman123 

 

Power BI does not allow converting more than 24 hours to time. Maybe you can get the average from seconds and convert to time format.

 

Best Regards,

Community Support Team _Charlotte

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