Colmumn not calculating time

[David Lambrecht]

Hi,

im trying to calculate the hour worked on tickets?

So i have a table  with a column hour worked.

On the column i set al the properties to time hh:mm:ss.

On the last cell i do a calculation =sum(c2:c40) but it doesnt calculate the times its stays on 0:00:00.

The property of the cell is custumfiel barchet h brachet:mm:ss

The only way that i can mak it count is when in go with my cursur on the cell go to the text abobe to adjust and press enter.

Then the text shifts to the right and its start to calculate.

you can see this in picture 1.

Offcourse i dont want to to all cells click enter ...

So is there a solution for this ?

Kind Regards,

David

[#2 · Accepted solution]

Hi David,

Your time initially is entered as text and SUM ignores any text. After you apply time format to your column with time select it, on ribbon Data->Text to Columns and you may press Finish on first step of appeared wizard.

[#3]

Hi Sergei

Indeed i found the same solution !

Thanks for the help it works!

Regards,

David