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.

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



Posted by Scott on March 23, 2000 7:26 PM


Thank you very much.