I know exactly what you mean. hyped up, feeling as if you are still full of energy and ready to go one moment, then some little sight, sound or just the unintentional tone is someone's voice happens and all of that energy from a moment agon goes into a meltdown that, to an observer, looks like a major rage fit or temper tantrum.
That's where we need ot use our logic, it's been a long day at work, you've done a lot, dealt with a lot of people and, logically should be tired but, you don't feel tired. For me that sets of a red warning light, that isn't right and, the only logical reason for that energy is anxiety energy, the stuff that causes a meltdown. So instead of using that energy, or trying to use it to keep going, and thus being out and about with my family or frined when that one last bit of slightly annoying or bothersome input comes along, thus setting off a meltdown, I know I need to go soak in a warm bath, put my iPod on and cook (cooking is relaxing to me) or, go into the studio (I have a small in home studio) and jam for half an hour to an hour until I feel tired like I should.
And yes, that pre meltdown high feels great, but, the crash is horrid if you miss it and don't bring yourself down peacefully. I know it ins't easy to think being full of energy is a bad thing, but, you need to look at when you are feeling full of energy, and, if you know you should be tired instead, odds ae you're getting close to a meltdown, time to process and decompress before all of that energy explodes toward family or friends, or co-workers.
Took me years to learn to recognize it, and know when being hyped up was bad news for me if I didn't get myself down off that energy ASAP but, I finally got it. Not that life doesn't make taking a time out impossible now and then, and thus I have a meltdown but, at least I know it's coming and, can warn those close to me that know I'm an Aspie that whatever we have to do isn't going to end pretty for me so, as soon as we get out of public view, stay clear unless you want whatever I might be throwing hitting you. (I tend to throw things, big heavy things most of the time, like guitars, amps, chairs, cast iron cookware, a marble dragon statue once- right through a posh hotel room window.)
Try to explain it to your family and, take that 30 minutes and, if cooking is relaxing to you, all the better, just tell them to stay out of the kitchen while you cook either dinner or dessert. Still productive but, you get time to process and decompress too.