Strip date and keep time from row of cells

**Christians** · 04-13-2011, 01:42 PM

Hi!

I've recently converted a few hundred lat/long positions into degrees and have cells with degree values formatted as: [t],mmss

My posistions display as (for instance) "59,4302", which is exactly how I want them. I copied the cells with conversion formulas (lat/long to degrees) retaining values only, and I'm left with cells that display correctly but have a value of (the one above) "02.01.1900 11:43:02".

Problem is that I need to create a csv file using the display value, is there a way to somehow make a new row of cells that has the display value as actual value? I'm using Excel 2007, if that matters, and I've tried using RIGHT and MID without any great success.

Hope my question made sense and that someone can help me out. This was harder than expected...

**ChemistB** · 04-13-2011, 02:45 PM

It would help to have your spreadsheet uploaded so I can see your formatting but try this....

=TEXT(A1, "h:mm:ss")
Does that work for you?

**Christians** · 04-13-2011, 02:50 PM

You, young man, just made it to the "thanks to" section of my masters thesis!

I wrote =TEXT(N2;"[t],mmss") instead, though, but still: THANK YOU!

(I'll probably come back and bug you guys later on, but I'm good for now at least)