Calculate/Sum duration by day

[young351]

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. 

[v-zhangti · Accepted solution]

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.

[vojtechsima]

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.