Dear excel heroes
•
20 Apr 2012, 14:44
•
Journals
Hai friends!
This is a loooooong shot but I request your help on the following urgent matter:
Im working on an analysis and I want to extract the hours (and possibly hours+minutes -> written like "hhmm") from a column with a date & time string thats written in this way: "10-10-2011 08:20:33". Strings differ ofc.
I tried using MID, but that didnt work out possibly due to the 'punctuation' in the string.. all I got was random numbers. Next I tried SUBSTITUTE to remove all non-numerical characters and got more random poop and thats were i stranded and got desperate :)
Any help is muchos appreciated!
This is a loooooong shot but I request your help on the following urgent matter:
Im working on an analysis and I want to extract the hours (and possibly hours+minutes -> written like "hhmm") from a column with a date & time string thats written in this way: "10-10-2011 08:20:33". Strings differ ofc.
I tried using MID, but that didnt work out possibly due to the 'punctuation' in the string.. all I got was random numbers. Next I tried SUBSTITUTE to remove all non-numerical characters and got more random poop and thats were i stranded and got desperate :)
Any help is muchos appreciated!
But you can plaste 10-10-2011 08:20:33 and format as time if it doesnt automatically already
was it format cells?
Well actually the format didnt help at all :d -> i could format the column to 8:20 which is no good for my pivottable. When i try to extract the hours to a column i still end up with 40 as a number :s?