Forum Discussion
Calculate/Sum duration by day
I need to create a line graph that will tell me the duration (downtime) per day based off of the information below. Using the example below, I know my total duration (downtime) was 21 hrs and 56 min...
Hi, Anonymous
You can try the following methods.
Duration = TIME ( 0, DATEDIFF ( [Start Time], [End Time], MINUTE ), 0 )Best Regards,
Charlotte Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-zhangti
Community Support
Community SupportHi, Anonymous
You can try the following methods.
Duration =
TIME ( 0, DATEDIFF ( [Start Time], [End Time], MINUTE ), 0 )
Best Regards,
Charlotte Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.