Is there a way inn Excel to capture the value of a cell at a certain time in regular intervals?

Question

I have a shipping dashboard I'm working on, and I'm trying to find a way to record an hourly log of the value of shipped goods every hour, and make a live line graph based on it?

Starting on the left, I have a power query table which pulls data off a server every 5 minutes. The "today?" column checks if the ship date matches today's date, and filters out goods that were shipped yesterday, so you're only seeing goods that were shipped today.

In the blue pivot table on the right, I have combined ship value - the pivot table shows todays current shipped value (£178,924.81), and the past days combined total, as far back as the report goes. This one can be ignored.

To the right of this, I have a value which represents todays target. This is manually entered, and split between the 17 hours that the company is open for. Each hour, the target accumulates, so that by the time we reach hour 17, the target should be £525,000.00.

Towards the bottom, I have the current time, which is updated every minute.

I want to be able to compare the current time to the time in the table, and if the hour matches, display a "snapshot" of the shipped value in the accumulate column. Alternatively, I would like to take a snapshot of the shipped value at the turn of each hour, and populate each row accordingly, so that we have a log of how much we shipped each hour, and compare with each hours target.

Is this possible?

Thanks,