calculating hours

[Guest]

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

 

[Bob Phillips]

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

 

[Bob Phillips]

Sorry wrong formula

=SUM(INT(A1:A5))+INT(SUM(MOD(A1:A5,1))*100/60)+MOD(SUM(MOD(A1:A5,1))*100/60,
1)*60/100

still an array formula