Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
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, 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.

     

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

Hi, Anonymous 
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.