=SUM question
 

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

John

=SUM(A1:A3)*24

and format the result as General

Regards

Trevor


"John Smith" wrote in message
...
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

John

also new to News Groups ?

Please don't multi-post. You have had the same answer from two different
people in two different groups. The same people look at pretty much all of
the related groups so by doing this you're wasting everyone's time and
effort.

Regards

Trevor


"John Smith" wrote in message
...
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

See one reply to your post in m.p.e.newusers.

Please don't post the same message in multiple groups. It just fragments
any answers you get, and potentially wastes the time of those replying
to questions that have already been answered.

For tips on using these groups effectively, see

http://cpearson.com/excel/newposte.htm



In article ,
"John Smith" wrote:

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

Thank you.
I get 18!
Can you assist further please?
...and not sure what format the result as General means.
Thanks
John
--------------------


format the resulting cell with the custom format
[hh]:mm

"Trevor Shuttleworth" wrote in message
...
John

=SUM(A1:A3)*24

and format the result as General

Regards

Trevor


"John Smith" wrote in message
...
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

Point taken, Trevor.
-----------------
"Trevor Shuttleworth" wrote in message
...
John

also new to News Groups ?

Please don't multi-post. You have had the same answer from two different
people in two different groups. The same people look at pretty much all
of the related groups so by doing this you're wasting everyone's time and
effort.

Regards

Trevor


"John Smith" wrote in message
...
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

Ah, now understood and sorted.
TVM for the advice.
John
-------------------

"Trevor Shuttleworth" wrote in message
...
John

=SUM(A1:A3)*24

and format the result as General

Regards

Trevor


"John Smith" wrote in message
...
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