josephwalls
New Member
- Joined
- Dec 10, 2013
- Messages
- 3
I have a big report of elapsed times that show up as "1:34". I want to have the data be seen by excel as mm:ss but instead it shows up as the time of day (e.g. 1:34 = 1:34:00 a.m.). I am so lost I would appreciate any help. I need something that I can apply to a column of times approximately 200 rows long that converts them over to the mm:ss format so I can get an accurate mean of the data. Any assistance is greatly appreciated.
To duplicate what I've got going on just type the following into a cell "4 Mins 27 Secs", which is what I was given when I exported data to a csv file from our database. I then was instructed by our IT to just use Edit > Find/Replace > and replace " Mins " with ":" and " Secs" with [leave field blank]. Spaces are important. I then get 4:27 displaying in my field, the format is time. If I format the cell as [mm]:ss I get 267:00 in my field but the formula bar still displays 4:27:00 AM.
I've also tried to copy and paste special with only values but 2:26 becomes
"0.101388889" and still gets seen as 2:26:00 AM when I am just trying to get excel to see it as 2 minutes and 26 seconds. These are racing times which I hope to get averages and mean averages for but I am unable to with the current issue.
Thank you so much for all of your help!
To duplicate what I've got going on just type the following into a cell "4 Mins 27 Secs", which is what I was given when I exported data to a csv file from our database. I then was instructed by our IT to just use Edit > Find/Replace > and replace " Mins " with ":" and " Secs" with [leave field blank]. Spaces are important. I then get 4:27 displaying in my field, the format is time. If I format the cell as [mm]:ss I get 267:00 in my field but the formula bar still displays 4:27:00 AM.
I've also tried to copy and paste special with only values but 2:26 becomes
"0.101388889" and still gets seen as 2:26:00 AM when I am just trying to get excel to see it as 2 minutes and 26 seconds. These are racing times which I hope to get averages and mean averages for but I am unable to with the current issue.
Thank you so much for all of your help!