Archive of Mr Excel Message Board

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

Adding hours and minutes

Posted by janet on January 24, 2002 10:19 AM

Have JUST found your site. I have to do a spread sheet taking total hours and minutes worked each day, giving a weekly total and then a totalfor the month. No matter how I try I cannot get it right... i.e. 7 hr 27 8 hr 13 etc.

Re: Adding hours and minutes

Posted by Dave S on January 24, 2002 10:40 AM

You just need to format the cells. Go to the Format menu and click, Cells. Choose the Number tab and click time. Then select one of the formats that has seconds.

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.