Archive of Mr Excel Message Board
Back to Dates in Excel archive index
Back to archive home
Adding time values
Posted by Scott on March 23, 2000 11:55 AM
I have a worksheet that calculated the length of a person's shift according to their time in and time out. I then want to total the hours for my team each day, and each week. I am using the hh:mm format for time...ie: 13:30 = 1:30pm. When I try to add the range of hours together, it automatically starts from zero each time it reaches 24 hours. How can I keep it form doing that? If I have 50 hours scheduled in a day for my team I want it to reflect that.
Re: Adding time values
Posted by Celia on March 23, 2000 4:23 PM
Scott
Change the format to [hh]:mm
You can find lots of infomation re working with time/date cells at:
http://www.cpearson.com/excel.htm
Celia
Re: Adding time values
Posted by Scott on March 23, 2000 7:26 PM
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.