I am receiving data with date and time in the following format:
2004-01-26, 03:32:47
When I enter this into excel, this pastes in one column. I want to be able to do some date/time calculations on this. eg difference between two numbers or subtract some hours from this number.
The format as it exists is clearly not correct for excel to do these calculations. In fact, I think excel just considers this to be a 'general' number. How should I go about getting this into the correct format.
I dont mind splitting the date and time into two columns or can leave it in one.
Tx
Stuart
2004-01-26, 03:32:47
When I enter this into excel, this pastes in one column. I want to be able to do some date/time calculations on this. eg difference between two numbers or subtract some hours from this number.
The format as it exists is clearly not correct for excel to do these calculations. In fact, I think excel just considers this to be a 'general' number. How should I go about getting this into the correct format.
I dont mind splitting the date and time into two columns or can leave it in one.
Tx
Stuart