How to convert time into decimals in Excel

If you have time stored as 1:30 but want it as a decimal (1.50), or if you want to convert time to minutes/seconds this is the tutorial for you! Converting time into decimals is easy once you know these three ways to do it. Arithmetic Way The easiest way to convert time to decimal in…

Excel: How to find cells exceeding a character limit

The example I’m using to demonstrate relates to product IDs and descriptions in WordPress, but many stock management systems have character limits you need to be aware of when importing data. For example our system has a 30 character limit and special characters like “ or & will expand in HTML to take up at…