autosum not working

[Guest]

when I attempt to pull these values out of a report generated by a telephony
application into excel - I then format the cells as "time" 37:30:55 - then I
do the "autosum"
=SUM(I6:I12)
it returns the value 0:00:00 - I've also tried
=SUM(I6:I12)*24
***********************
I
6 00:17:06
7 00:12:18
8 00:09:24
9 00:06:48
10 00:10:18
11 00:22:00
12 00:10:36
***********************

However, if I go and type these values in the spreadsheet manually,
everything works fine. - has to be something with the formatting... can't
figure it out...

 

[David Biddulph]

Check that you haven't got spaces (or other non-printing characters) before
or after your times. If you do have, Excel will treat them as text.