Manage Projects Online.

 

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), a good report to export is the Time Summary report (found on the Reports Page).

Converting your Time to Minutes

If you have 1:30 and you want it in minutes (90 Minutes) then create a new column alongside your time figures then enter the formula ={cell}*1440

Cell Formula

Cell Formula

You’ll need to make sure the cells are being formatted correctly, so select your “Time” column, right click and select “Format Cells” then make sure you’ve set the cell type to Custom h:mm

Time Cell Format

Time Cell Format

Then do the same for your “Minutes” column and make sure the cell type is set to Number with no decimals

Minutes Cell Format

Minutes Cell Format

You should end up with a nice list.

The End Result

Got something to say? Go for it!