Help excel auto converts

[m_789]

Hi all,
I have all my agent stats in a spreadsheet in HH:MM:SS for some reason some of the fields auto change to a different field type i have highlighted it in the sheet
anyone have any ideas? E.G F5 should say 00:35:30
i have attached the spreadsheet so u can see this

[dilipandey]

Hi m_789,

Try dividing column F values with 60.
Type 60 in a spare cell, copy this, select column F values, paste special - values - divide.

Regards,
DILIPandey
<click on below * if this helps>