Sumation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
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.
 
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?
 
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...
 
Back
Top