What is 7:35? 7:35 AM? Or 7 hours and 35 minutes?

If it is the latter, format the cell in which you are doing summation as
number, not time.

Then =SUM(A1:A5)*24 will give you 37.92.

Dave


--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Bikertyke" wrote:

Why when I try to sum 5 days worth of 07:35's does the answer equal 22:00. My
formula {=sum(cell 1:cell 5)*24} I believe is correct as is the formatting,
i've tried time and custom hh:mm.
It should be so simple.