Thread: =SUM question
View Single Post
  #5   Report Post  
John Smith
 
Posts: n/a
Default

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