Hi, I copied & pasted data from a report onto an Excel Spreadsheet. I wish
to total a time duration column. The data is in the form 0:00:15 (15
seconds) or 0:13:50 (13 minutes, 50 seconds). Heres the trouble... I cannot
add these! I keep getting a total of 0:00:00. I have tried copying, then
hitting paste special and pasting the 'values', but to no avail. I have ties
various random formatting techniques, but again, to no avail. Funny thing
is, if I manually type the values, I can add. I would like to avoid this as
there are 100's of values... hopefully, someone has encountered this before
and can be of assistance.