As I said, I don't want to faff around with a spreadsheet or a calculator. I don't want to have to work it out for myself. I don't see why the ride logging sites such as ridewithgps or strava only present moving average, when they have the figures there to present the real average. What's more, they have the cheek to call it "average speed" when it's nothing of the sort. It's a made-up figure just to flatter me.
Take the example I gave above. It's massively unlikely that I could maintain 22km/h in a 200k time trial, yet ridewithgps has managed to scrape together enough brief stops to make it look like that. The reality is that, even if I scrimped on the stops, and got lucky with the traffic lights or rode on closed roads, the lack of rest would get to me, and by reducing my rest times the overall average would come down. So the silly moving average figure that RWGPS gives me is misleading when I come to consider whether I can get round Velo Wales inside the cutoff. I know that the cut-off speed of 19km/h is going to be unlikely/very hard, and I know this by calculating real averages and ignoring moving ones.
If I took an hours lunch in the middle of a two hour ride, I'd just accept that it was a slow ride, because it was. I was out for 3 hours.