Forum Discussion

young351's avatar
young351
Frequent Visitor
4 years ago
Solved

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...
Tips and Tricks
  • v-zhangti's avatar
    v-zhangti
    4 years ago

    Hi, young351 

     

    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's avatar
v-zhangti
Icon for Community Support rankCommunity Support
4 years ago

Hi, young351 

 

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.