# Pls help. Excel graph question.

#### Supernova_26

##### New Member
Hello,
Pls don't bash me but I have reached my limits with excel I am looking for some help with some statistical help. I have 3 data columns Date of Measure/ Time of Measure/ Voltage Measurements. I have 31 days of data with samples every 2 min. The time is shown in 24hrs format. Is that a way for me to graph how long each power outage lasted each day. A power outage condition happens when voltage is less then 5 volt.

Example
Date of meas Time of meas. Voltage
12/12 23:22 110
12/12 23:24 0
12/12 23:26 0
12/12 23:28 110

So is that a way for me to graph the date 12/12 and see that I have a power outage that lasted 4 min.
Thank you so much
Toni

### Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.
 Time Volts Is Outage Start Is Outage End Duration 00:00 0 1 1 2 00:02 110 0 0 #N/A 00:04 0 1 0 4 00:06 0 0 1 #N/A 00:08 110 0 0 #N/A

<tbody>
</tbody>

The upper left corner is cell A1.

C2: =IF(B2, 0, 1)
C3 and copied down: =IF(AND(B3<>B2, B3=0), 1, 0)

D2 and copied down: =IF(AND(B2=0, B2<>B3), 1, 0)

E2 and copied down:=IF(C2 = 1, 2 * MATCH(1, D2:D721, 0), NA())

Plot "Duration" as a column chart using "Time" as the horizontal axis.

Thank you so much for your help. This worked very well

You are welcome. Thank you for providing feedback.

Replies
1
Views
78
Replies
1
Views
80
Replies
1
Views
184
Replies
2
Views
222
Replies
2
Views
140

1,196,379
Messages
6,014,951
Members
441,857
Latest member
saraguchi2316

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back