When I was looking for earbuds for long-term wear, I ran into the fact that good low-frequency noise cancellation is only half the battle. Sony really does handle the rumble well, but I was missing the comfort of fit for a full day - my ears would get tired.
Nothing Ear is more comfortable to wear, but if battery life is critical specifically for 8 hours straight - that could be a problem, because in reality you get less.
For an office setting I'd still lean towards Sony if you're sitting in one place and don't move around much, but try both beforehand if you can - the fit might end up being the deciding factor for you.