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
|