Time calculations

[steveridge]

Hi
I have a problem in excel and i know its simple but my brain is not working. I have a column of time as shown below but when I try and add them up it returns 0. Also the auto count at the bottom left only counts

I made sure the cells were formatted to time (hh:mm:ss) but still nothing. Someone please help me!!

 

[MARK858]

Formatting doesn't change the underlying value, it just changes the appearance of the cell.
Your times look like text to me, try...

• Select the cells or column
• Data tab
• Text to Columns
• Delimited
• Next
• Make sure all the checkboxes are cleared
• Next
• Select the General option
• Click Finish
• Format the cells as desired

 

[steveridge]

Formatting doesn't change the underlying value, it just changes the appearance of the cell.
Your times look like text to me, try...

• Select the cells or column
• Data tab
• Text to Columns
• Delimited
• Next
• Make sure all the checkboxes are cleared
• Next
• Select the General option
• Click Finish
• Format the cells as desired

That worked a treat, thank you so much Mark as thats been hindering me all morning!!

 

[MARK858]

Happy it helped and welcome to the forum