MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Calculating hours and minutes

Posted by Julie Rea on November 21, 2001 2:19 PM

I wonder if someone could help. I have been given a task to enter hours and minutes onto a spreadsheet. For example 1 hour 23 minutes. How does one do this?? Also I need to add up columns of these with the normal add sum do??

Posted by Dan on November 21, 2001 9:37 PM

You can just enter it as 1:23 and format the cell with [h]:mm (right-click on the cell, select Format, choose Custom, type [h]:mm). Format all of the cells that will have times like this, including the cells that are summing the times. Yes, you can use the regular SUM function.


P.S. If you need it to display "1 hour(s) 23 minute(s)", rather than just "1:23", do everything above, except format the cells as: [h]" hour(s) "mm" minute(s)"