A bit late to the party here, but I discuss how to do this in my article on using Zapier with HubSpot here.
Would love to see calculated fields built into the CRM, though. It would eliminate our need to need to leverage other tools (like zapier and google sheets) for a handful of our basic CRM usage.