Summing Short Time data type

  • Thread starter Thread starter Scott
  • Start date Start date
S

Scott

i've imported a column of short date times like below and trying to add them
up. Is there a certain format that can be used to add them? I just get 00:00
as the total.


00:10 '10 minutes
00:07 ' 7 minutes
 
Maybe they have imported as text? That would explain the 00:00
If I put 00:10 in A1 and 00:07 in A2 and do =SUM(A1:A2)
I get 00:17

press F5, click special, select constants and uncheck everything but text,
if they get selected they are text
 
Back
Top