Sumation

B

Bikertyke

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.
 
D

Dave F

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
 
D

David Biddulph

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.
 
B

Bikertyke

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?
 
B

Bikertyke

Thats perfect. Thanks for the support.

David Biddulph said:
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 said:
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.
Click to expand...
Click to expand...
 
Top