=SUM question

J

John Smith

New to excel.
Can I use a =SUM formula to add a column of times. eg 12:15+03:30+10:00 and
have the answer in fractions...in this case 25.75
Thanks
 
F

Frank Kabel

Hi
use
=SUM(A1:A10)
and format the resulting cell with the custom format
[hh]:mm
 
D

Dave Peterson

try:

=sum(...)*24

(format as General)

John said:
New to excel.
Can I use a =SUM formula to add a column of times. eg 12:15+03:30+10:00 and
have the answer in fractions...in this case 25.75
Thanks
Click to expand...
 
J

John Smith

Thanks.
I get 18!
Can you help further please :)
Not sure what you mean by format the resulting cell with the custom format
[hh]:mm



Frank Kabel said:
Hi
use
=SUM(A1:A10)
and format the resulting cell with the custom format
[hh]:mm

--
Regards
Frank Kabel
Frankfurt, Germany

John Smith said:
New to excel.
Can I use a =SUM formula to add a column of times. eg 12:15+03:30+10:00 and
have the answer in fractions...in this case 25.75
Thanks
Click to expand...
Click to expand...
 
B

Brian Hoy

John said:
New to excel.
Can I use a =SUM formula to add a column of times. eg 12:15+03:30+10:00
and have the answer in fractions...in this case 25.75
Thanks
Click to expand...

Hi John,

Times are stored as a fraction of 1 day e.g. 18:00 is stored as 0.75.
So you will need to format your summation as a general number, and multiply
it by 24 as well. Hope this helps.

Regards,
Brian Hoy
 
J

John Smith

Brian Hoy said:
Hi John,

Times are stored as a fraction of 1 day e.g. 18:00 is stored as 0.75.
So you will need to format your summation as a general number, and
multiply
it by 24 as well. Hope this helps.
Click to expand...
-------, please send your crap to my honeypot at [email protected]
 
Top