Archive of Mr Excel Message Board

Back to Dates in Excel archive index
Back to archive home

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??

Re: Calculating hours and minutes

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)"

This archive is from the original message board at
All contents © 1998-2004
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.