How to Create Pivot Tables?

What is a Pivot Table? Spending too much time analyzing data? PivotTables automatically sort raw data into a table or spreadsheet, displaying the results on a separate table showing the summarized data. PivotTables can save you a lot of time, work and give you insights into your data that you may have missed or is […]

Converting Time into Decimals using Excel

Something I’ve had many customers asking is how they can convert their time figures into decimals using a spreadsheet, it’s something that’s really easy to do if you know the correct formula to use. I’m going assume that you’ve exported the data from our system so it’s in the format 1:30 (1 hour, 30 minutes), […]

Converting Time into Minutes using Excel

Something I’ve had many customers asking is how they can convert their time figures into minutes using a spreadsheet, it’s something that’s really easy to do if you know the correct formula to use. I’m going assume that you’ve exported the data from our system so it’s in the format 1:30 (1 hour, 30 minutes), […]