Forum Discussion
Solved
Colmumn not calculating time
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 ca...
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.
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.
Hi Sergei
Indeed i found the same solution !
Thanks for the help it works!
Regards,
David
