The Poojer Posted June 17, 2009 Share Posted June 17, 2009 i feel like a frigging idiot here...trying to create a spreadsheet to track my son's swim times. I am formatting some columns as 'general' so i can do <seconds:hundreths of seconds>. 2 of the columns are working fine, the 3rd keeps chaning formats on me.....damn it is frustrating the hell out of me because i know i am missing a really basic step.....HELPPPPPPPPP!!!!!!! Link to comment Share on other sites More sharing options...
plenzmd1 Posted June 17, 2009 Share Posted June 17, 2009 i feel like a frigging idiot here...trying to create a spreadsheet to track my son's swim times. I am formatting some columns as 'general' so i can do <seconds:hundreths of seconds>. 2 of the columns are working fine, the 3rd keeps chaning formats on me.....damn it is frustrating the hell out of me because i know i am missing a really basic step.....HELPPPPPPPPP!!!!!!! Pooj, where do you all swim. My kids are on the RCC team in JRAC, and also NOVA in the winter. Your son swimming either NOVA or Poseidon? Link to comment Share on other sites More sharing options...
damj Posted June 17, 2009 Share Posted June 17, 2009 i feel like a frigging idiot here...trying to create a spreadsheet to track my son's swim times. I am formatting some columns as 'general' so i can do <seconds:hundreths of seconds>. 2 of the columns are working fine, the 3rd keeps chaning formats on me.....damn it is frustrating the hell out of me because i know i am missing a really basic step.....HELPPPPPPPPP!!!!!!! Pooj ... it's not you ... I know what you're talking about it ... I just recently starting seeing that happen in Excel 2003 ... sucks and is aggravating. I have no idea why ... It always to change formulas to "text" format, so you have to reset the format to general, then hit "F2" and enter to reset. I'm a MicroCrap hater! Link to comment Share on other sites More sharing options...
damj Posted June 17, 2009 Share Posted June 17, 2009 Your son swimming Poseidon? That must be quite an adventure, especially the morning after. {groan} Now you'll have that song stuck in your head all day, wish you luck with that {mwah ha ha} Link to comment Share on other sites More sharing options...
The Poojer Posted June 17, 2009 Author Share Posted June 17, 2009 no we are RMAL and we are Shenandoah, I may look into year long, he shows some promise, especially in backstroke Pooj, where do you all swim. My kids are on the RCC team in JRAC, and also NOVA in the winter. Your son swimming either NOVA or Poseidon? Link to comment Share on other sites More sharing options...
Kevbeau Posted June 17, 2009 Share Posted June 17, 2009 Go under Format Cells:Number:Custom and choose mm:ss That should get you what you need. Link to comment Share on other sites More sharing options...
Fezmid Posted June 17, 2009 Share Posted June 17, 2009 Your problem is that you're not using Open Office. Link to comment Share on other sites More sharing options...
/dev/null Posted June 17, 2009 Share Posted June 17, 2009 Your problem is that you're not using Open Office. It took you 1 hour and 33 minutes to make that remark. You're slipping dude Link to comment Share on other sites More sharing options...
Fezmid Posted June 17, 2009 Share Posted June 17, 2009 It took you 1 hour and 33 minutes to make that remark. You're slipping dude That's because I'm getting more and more swamped with work.... Link to comment Share on other sites More sharing options...
/dev/null Posted June 17, 2009 Share Posted June 17, 2009 That's because I'm getting more and more swamped with work.... I know that feeling Link to comment Share on other sites More sharing options...
The Poojer Posted June 17, 2009 Author Share Posted June 17, 2009 trying that....it keeps changing the format to read it as if it is a date....55:81 translates to January 3, 2009 3:58 or something like that.....it is killing me Go under Format Cells:Number:Custom and choose mm:ss That should get you what you need. Link to comment Share on other sites More sharing options...
\GoBillsInDallas/ Posted June 17, 2009 Share Posted June 17, 2009 i feel like a frigging idiot here...trying to create a spreadsheet to track my son's swim times internet porn viewing. I am formatting some columns as 'general' so i can do <seconds:hundreths of seconds>. 2 of the columns are working fine, the 3rd keeps chaning formats on me.....damn it is frustrating the hell out of me because i know i am missing a really basic step.....HELPPPPPPPPP!!!!!!! Fixed. Link to comment Share on other sites More sharing options...
justnzane Posted June 17, 2009 Share Posted June 17, 2009 Fixed. nice. The real question is who else tracks their porn viewing with excel, besides me ? Link to comment Share on other sites More sharing options...
/dev/null Posted June 17, 2009 Share Posted June 17, 2009 nice. The real question is who else tracks their porn viewing with excel, besides me ? Dude you need some way to keep track of it all. I just hacked your computer and saw how much you have # du -sh c:\porn 75M donkey 350G gay 0M girls 50M midgets 10M sarah palin Link to comment Share on other sites More sharing options...
Recommended Posts