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, but I need a calculation to tell me the duration on the 26th and the 27th in order to graph this out. 

 

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.

     

2 Replies

  • vojtechsima's avatar
    vojtechsima
    Icon for Super User rankSuper User
    4 years ago

    Hi, young351 
    You can use DATEDIFF function to retrieve the time from midnight to the start of the start day, and from midnight to end for the next day if the downtime exceeds one day.
    However, if you could provide sample data that can be copied, I could create a tailor-made solution for you.

  • 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.