I've got a spreadsheet that I am trying to make. I downloaded some information from our database, but when excel looks at the information in the cell, it sees it as a date.
It views in the cell looking at it as 2:18, which it should mean 2 minutes and 18 seconds. But within the cell itself, excel is reading it as 12:02:18 AM. Definitely not what I need.
What I need is 2 minutes 18 seconds, because I need to average the time.
Any suggestions?
It views in the cell looking at it as 2:18, which it should mean 2 minutes and 18 seconds. But within the cell itself, excel is reading it as 12:02:18 AM. Definitely not what I need.
What I need is 2 minutes 18 seconds, because I need to average the time.
Any suggestions?