Hi Junker,
I remember such a question in the german section of the forum. @radiorom started this in October 2010 (!) with 1’440 tracks (24-hour-format).
Ten years later he explained it here: Zeitansage bei mairlist 6.2 - #6 by radiorom
The important paragraph translated:
We have a directory where 1440 mp3 files are stored, so one for every minute of the day. We add a special element to the playlist that accesses the corresponding file using the current time %h%m.
As a part of the hour template in the database: Yes, this should be possible.