I added 10 days 5 hours five times which should of given me 51 days 1 hour.
Instead I got 20 days 1 hour which is Feb 20,1900 (the 51st day of the year
1900 at 1:00AM)!!!!!

You can use this to get the correct results but it will be in text format
not a number.

=INT(SUM(C1:C5))&TEXT(SUM(C1:C5),":h")





"Basenji" wrote:

I have a column of start days and times, 12/8/08 15:00, and end days and
times, 12/18/08, 20:00. I subtract the two columns to get the number of days
and hours between the two times, which is formatted with a "d:h" custom
format to show the rounded off number of days and hours, 10 D 5 H. This
column of time differences needs to be added and averaged. The sum function
does not show a correct total nor dos the average function show a correct
average. Is it a function issue or a formatting issue? The total for the
hours and the average of the time differences should be in a day hours
format, d:h, or some format that will show the total or average days and
hours. I have experimented with a varity of formats and tried different
functions but have been so far unsuccessful. Any assistance would be
appreciated. Thank you.