The problem is that 3.30 is not 3 hours 30 but 3 hours 18, so you need to
convert it.

Assuming times in A1:A5, use

=SUM((A1:A5)*100)/100

which is an array formula so commit with Ctrl-Shift-Enter

--
HTH

Bob Phillips

"bus2408" wrote in message
...
I am having a problem with calculating time in excel. I have a work sheet
that tracks how many hours each person has per day then gives a total of
hours at the end of the week. Here is the problem-when it reaches 60 mins
it
doesn't add another hour. Exampel: 7.27 hours + 3.30 hours + 8.15 hours +
3.00 hours + 5.22 hours = 26.94 this should read 27.34. so the question is
how do i get excel to round it to the correct hour/min reading. I am
unsing
excel 2000