Forum Discussion
Calculate Duration from date time fields
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 ) * 3600Best 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.
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.
Thanks, that does give me the reuslts I want but can it be formatted to Time so I can take the Average Time?
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.