Hi

I would guess you have got leading or trailing blanks in the cells - which
means that Excel does not recognise it as a time. I doubt anyone on this
forum would open your attachment to check it, however.

Andy.

"ludikris" wrote in
message ...

Hi,

I view my rogers phone bill online and it allows me to save it as a pdf
that I can access later... I then import the date using the table select
function but when I try to sum the table, I get zeros.

for example..

10:00
22:10
16:00

=sum(a1:a3) the formula
00:00 what I see
48:10 what I should get.

Can someone help me solve this ?

the .xls is attached in zip format...

Thanks !!


+-------------------------------------------------------------------+
|Filename: rogers test.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4416 |
+-------------------------------------------------------------------+

--
ludikris
------------------------------------------------------------------------
ludikris's Profile:
http://www.excelforum.com/member.php...o&userid=32140
View this thread: http://www.excelforum.com/showthread...hreadid=518973