Sumation
 

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.

Sumation
 

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.

Sumation
 

If you want the answer in time format, leave out the multiplication by 24,
and format as [h]:mm to cope with the wrap-round when the answer is more
than 24 hours.
If you want the answer in numbers of hours (as a decimal number), then your
multiplication by 24 is right, but you need to format the answer as number
or general.
--
David Biddulph

"Bikertyke" wrote in message
...
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.

Sumation
 

That works perfectly, and you where correct in your assumption. Cheers
Would be nice to have the answer as a time i.e. 37:55 rather than a number.
Is it possible?

"Dave F" wrote:

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.

Sumation
 

Thats perfect. Thanks for the support.

"David Biddulph" wrote:

If you want the answer in time format, leave out the multiplication by 24,
and format as [h]:mm to cope with the wrap-round when the answer is more
than 24 hours.
If you want the answer in numbers of hours (as a decimal number), then your
multiplication by 24 is right, but you need to format the answer as number
or general.
--
David Biddulph

"Bikertyke" wrote in message
...
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.