View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
thom hoyle thom hoyle is offline
external usenet poster
 
Posts: 24
Default Sum ? / Numbers with Text

I have a dump from out phone cost accounting system: It outputs for the
DURATION of the call in a column like this.

0 hrs. 2 mins. 44 secs.
0 hrs. 4 mins. 2 secs.
etc..
etc...

I need to sum the total of this data to output Total HRS, MINS, SEC, and
havn't got a clue on how to start.

thanks