Posted to microsoft.public.excel.misc

external usenet poster

Posts: 2

autofill timestamp

I have a table with over 4000 records collected with a gps every second, but
the timestamp it gives does not make sense (eg.78419863). I am looking for
some help to calculate the values of a field so that it takes the first
record of the field and adds 1 second to each record after the first time. Is
it possible to have the timestamp read hh:mm:ss

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
Timestamp	juanpablo	Excel Discussion (Misc queries)	3	November 2nd 07 01:55 PM
Timestamp ?	elroyerni	Excel Discussion (Misc queries)	2	June 1st 07 12:07 AM
Timestamp	PS	Excel Discussion (Misc queries)	2	January 10th 07 02:21 PM
Now as timestamp	Lp12	Excel Worksheet Functions	5	August 13th 06 11:32 AM
Autofill: Need to autofill one week block, (5) weekday only into cells.	dstock	Excel Discussion (Misc queries)	1	June 17th 05 08:21 PM

All times are GMT +1. The time now is 02:04 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us