Nordpool 15-min intervals to hourly averages

Hello,
I have a situation where Nordpool gives data in 15-minute slots but my power consumption is still measured in 1-hr intervals by the electricity seller.
This situation will continue until they physically change my meter (time unknown, might take years).

AIO is working fine with “mtu: 60” but for some other automations I would need hourly averages generated from 15-minute slots.
Has anyone already implemented the working solution for NP 96>24 units conversion for hourly averages? This goes beyond my very limited abilities.

[I have the official Nordpool integration and updated HA (2025.10.2 now).]

Thanks.