Posted to microsoft.public.excel.programming

andrew@obo andrew@obo is offline

external usenet poster

Posts: 1

SQL Millisecond date to usable excel timestamp

Basically, I want the SQL time to read as an actual date/time, but I
don't know how to make this calculation in Excel (or anywhere else)

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
millisecond	Dan	Excel Worksheet Functions	7	January 23rd 08 10:34 AM
Formating a timestamp as a date and time.	Dan	Excel Worksheet Functions	3	April 20th 07 05:38 PM
Converting UTC timestamp value to date and time	SK	Excel Discussion (Misc queries)	1	March 19th 07 02:40 AM
How to set the time in millisecond	jaizovic	Excel Discussion (Misc queries)	1	August 4th 06 02:46 AM
Convert Unix timestamp to Readable Date/time	Emily	Excel Worksheet Functions	2	January 26th 06 11:59 PM

All times are GMT +1. The time now is 02:14 AM.

About Us

"It's about Microsoft Excel"