ADD TIME DURATION

[Dan]

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.

 

[ShaneDevenshire]

Hi,

Try formatting all the cells to [h]:mm:ss including the total cell.

 

[David Biddulph]

My guess would be that you haven't actually got Excel times (numbers) in
those cells, but instead you've got text that looks vaguely like times. You
can get a clue by trying to change the time formatting temporarily, and see
whether it changes. If it doesn't change to your new format, it's probably
text. Another way of checking is with the ISTEXT and ISNUMBER functions.

It may be as simple as having spaces before and/ or after your time. You
might be able to solve it by =--TRIM(A2) and formatting the resultant cell
appropriately.