Search Results

thanks for all the suggestions... will carry on working on it today and will let you know how i got on.

I have other files already in this format, so I want to keep the formats the same.
In addition, i don't want to risk opening it in excel and seeing the formats change.


i've added a second ...

many thanks
will speak with them.

---------- Post updated at 03:23 PM ---------- Previous update was at 01:57 PM ----------

i have code that converts from the data format mentioned into epoch....

Thanks Andrew.
I did indeed mean serial date (i've just edited my original question).
What I'm looking for is the date used in excel.

so really converting any of those data/timestamp strings in...

Hi,
I have a data file where the timestamp is in the style of:
2016-10-11 07:01:23.375-500

which is yyyy-mm-dd hh-mm-ss-000 then time conversion from UTC

What i need to do is convert these...