Relative Content

Tag Archive for excel

Converting general formatted date/time into real date/time in excel

I have a data set exported from Oracle to excel. There is a column with what appears as Date/Time in the format mm/dd/yyyy hh:mm:ss.
However, it is not a number. It is formatted as general. No amount of converting has worked yet. I need to get it to convert to a standard date/time format in excel.

Nested IF Statements in Excel Formula

So, to preface, I’m a complete novice at this Excel business. I’ve found similar examples via Google of how to do this, so I don’t think I’m too far off: