Archive of Mr Excel Message Board

Back to Forms in Excel VBA archive index
Back to archive home

Adding Times

Posted by Elizabeth on February 08, 2001 9:35 AM

I have a list of times from our call center and we are trying to add up a column of times to get a total time for each month. The sum function gives 0 as the result. I can add each cell together and get a total time (i.e. 01:15+05:30=06:45) but there are over 50 cells in each column. Can anyone help?

Thanks,
Elizabeth

Re: Adding Times

Posted by wayneo on February 08, 2001 1:47 PM

Elizabeth,

Check and make sure your column is formated in hr:mm:ss. Then sum your 50 or so items. To do this... select your column.... then "Format"..."Cell"..."Time"..."Type"...."37:30:55". This will take into account a sum which is greater that 24 hours.

Hope this helps

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
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.