Time calculation based on time stamp

[ArnabSengupta]

Hi All,

I have a data set of different machine state (running, error, idle etc.) I want to calculate how long the each machine spends on different state's per day and per machine. The time stamp is given in descending order with the first record being latest

I have attached a sample data set.

[BrandonB · Accepted solution]

The Multi-Row tool allows you to reference cells above and below the current cell as shown below