Here's my own interpretation:
There have been times in my life when some tragic event, often preventable (but not reversible), suddenly hits. The combination of it being preventable but not reversible is quite surreal. As a result, I find myself reliving that tragic moment, over and over, in my head. It happened such a short time ago -- hours, or even minutes ago -- yet I am powerless to change its course.
Even the following day I find myself thinking about the event, over and over and over. The 24-hour mark (a whole day since it occurred) hits especially hard. It's odd to think that 25 hours ago life was relatively good, and then one hour later everything suddenly irrevocably turns upside-down.
It's almost like I long to reminisce about the good times; however, these "good times" are not the times I experienced years ago, but simply the ones I experienced yesterday, before the tragic event transpired.
To me, this is what it feels like Paul McCartney is singing about. Just a few short 25 hours ago, life was beautiful and enjoyable. But then, something hit to make life veer off in an unwanted direction. And now, all I can do is helplessly reminisce about all that I lost since yesterday.
Paradoxically, even though grief hit me just a day ago, it feels like I've been grieving for a hundred years. And it's that very paradox that is what (it feels to me that) Paul is singing about: A hundred years of suffering and grief came suddenly -- not a century ago, but yesterday.