Hi all,
I'm trying to create a graph to show energy consumption between certain hours and the data I have is imported into excel every half hour.
Column A is a Kwh value column B is a start time stamp column c is a finish time stamp
What I would to do is column D is if the time stamp is between '05:30 to 23:00 on the same day return the value in A
In column E the same principal, but show the data from column A if the time stamp is between 05:30-23:00
Could anyone with a formula to do this as I need to plot both lines on a graph.
Thank you and I hope that explains it
snap of data below
I'm trying to create a graph to show energy consumption between certain hours and the data I have is imported into excel every half hour.
Column A is a Kwh value column B is a start time stamp column c is a finish time stamp
What I would to do is column D is if the time stamp is between '05:30 to 23:00 on the same day return the value in A
In column E the same principal, but show the data from column A if the time stamp is between 05:30-23:00
Could anyone with a formula to do this as I need to plot both lines on a graph.
Thank you and I hope that explains it
snap of data below
Consumption (kWh) | Start | End |
0.394 | 2022-10-01T00:00:00+01:00 | 2022-10-01T00:30:00+01:00 |
1.14 | 2022-10-01T00:30:00+01:00 | 2022-10-01T01:00:00+01:00 |
0.068 | 2022-10-01T01:00:00+01:00 | 2022-10-01T01:30:00+01:00 |
0.089 | 2022-10-01T01:30:00+01:00 | 2022-10-01T02:00:00+01:00 |
0.052 | 2022-10-01T02:00:00+01:00 | 2022-10-01T02:30:00+01:00 |
0.067 | 2022-10-01T02:30:00+01:00 | 2022-10-01T03:00:00+01:00 |
0.038 | 2022-10-01T03:00:00+01:00 | 2022-10-01T03:30:00+01:00 |
0.058 | 2022-10-01T03:30:00+01:00 | 2022-10-01T04:00:00+01:00 |
0.086 | 2022-10-01T04:00:00+01:00 | 2022-10-01T04:30:00+01:00 |
0.073 | 2022-10-01T04:30:00+01:00 | 2022-10-01T05:00:00+01:00 |
0.066 | 2022-10-01T05:00:00+01:00 | 2022-10-01T05:30:00+01:00 |