Spikenaylor
Board Regular
- Joined
- Apr 14, 2013
- Messages
- 115
- Office Version
- 365
- Platform
- Windows
I have a list of date and times which an item was entered into a fridge
the fridge has a humidity and temperature sensor, both could indicate individually that the fridge has gone out of spec and then come back in.
I have calculated a list of times the fridge is completely back in spec
I now need to show in column B for each item entered, the time the fridge has completely come back in spec.
<tbody>
</tbody>
It is basically get the next highest time in Z for the value in A
just struggling to get it to work
I seem to just continually get one result of 12:44, when there should be two results of 12:44
any pointers greatly received
many thanks for looking
the fridge has a humidity and temperature sensor, both could indicate individually that the fridge has gone out of spec and then come back in.
I have calculated a list of times the fridge is completely back in spec
I now need to show in column B for each item entered, the time the fridge has completely come back in spec.
A | B | C | Z | ||||||
Time item into fridge | Time fridge fully back in spec for this item, (what the value should be) | Calculated times fridge back in spec | |||||||
10:47 | 11:01 | 11:01 | |||||||
11:06 | 11:24 | 11:24 | |||||||
11:36 | 11:57 | 11:57 | |||||||
12:03 | 12:44 | 12:44 | |||||||
12:25 | 12:44 | 13:24 | |||||||
12:52 | 13:24 | ||||||||
13:04 | 13:24 | ||||||||
<tbody>
</tbody>
It is basically get the next highest time in Z for the value in A
just struggling to get it to work
I seem to just continually get one result of 12:44, when there should be two results of 12:44
any pointers greatly received
many thanks for looking