Adding times.....

[rcdunn2003]

I know it may seem simple, but I have yet to get a formula to work
adding times. A report spitting out times for our production area is
xferd to a spreadsheet and need to total these times in either time
format (h:mm) or 2 place decimal format (2.35). Can anyone help me with
this one please?

File Attached: http://www.exceltip.com/forum/attachment.php?postid=308661 (productivity matrix.xls)

 

[Chip Pearson]

You can add times as normal numbers, using either the + operator or the SUM
function. You should give the result cell a custom number format of [hh]:mm
or [hh]:mm:ss to prevent Excel from "rolling over" the result at 24 hours.

 

[Intruder9]

Do a search here, there should be plenty of ideas to give you an idea.
http://groups.google.com/groups?num=100&hl=en&lr=&ie=ISO-8859-1&scoring=d&as
_drrb=b&q=group%3A*Excel*+insubject%3Atime&as_mind=13&as_minm=9&as_miny=2001
&as_maxd=13&as_maxm=9&as_maxy=2003