Thread: =SUM question
View Single Post
  #2   Report Post  
Trevor Shuttleworth
 
Posts: n/a
Default

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