htm date & time format
Thanks!
"Shane Devenshire" wrote:
Hi,
You can split this type of data by choose Data, Text to Columns and choosing
Fixed Width, Next, then click between the 8th and 9th character in the Date
Preview pane (between the date and the time) and a second one between the
10th and 11th character (between the hours and minutes. Click Next,
determine the destination and, in the data preview pane click in the first
column and from the Date drop down choose YMD. Click Finish.
Let's say the destination cell was A1, you get three cells for each entry
Date in column A, hours in B and minutes in C
In D1 enter
=A1+TIMEVALUE(B1&":"&C1)
Format this as you need
Cheers,
Shane Devenshire
"Rob" wrote:
I have opened a htm data set in Excel 2003 that contains the date & time as
yyyymmddhhmm (the cell is formatted as general) and need it to display as
mm/dd/yyyy hh:mm.
For example 199704010053 in cell A1 currently displays as 1.99704E+11. I
would like it to display 04/01/1997 00:53.
I have tried custom formatting but end up with ###... and hovering the mouse
over the cell results in "Negative dates and times are displayed as ####"
What is the correct formula and cell formatting?
The htm data set dates & times are GMT and I need to convert it to PST/PDT.
Is this possible or would it be a seperate formula?
|