=SUM question

  • Thread starter Thread starter John Smith
  • Start date Start date
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
 
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...
 
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...
 
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
 
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 (e-mail address removed)
 
Back
Top