Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How am i able to populate a sumation for multiple sheets | Excel Worksheet Functions |