Converting a number to Date and Time

**Fabbyfil** · 01-21-2011, 07:30 AM

Hi

I have a Time_Col which seem to sort an interger in the following format

931897380
931897440
931897500
931897560
931897620
931897680
931897740

There is 60 between each one, is there a way I can convert this number into a date and time which I assume it is but not sure how far back it goes or starts from

Many Thanks

**DonkeyOte** · 01-21-2011, 07:39 AM

It will be hard to convert to an accurate date time value if you don't know the starting point (ie date time at 0)

If you want to convert the integer to "any date time" value then assuming the values represent seconds - divide each by 86400 and format as Date.

If you want to alter originals directly type 86400 into a blank cell, copy it, highlight originals & apply paste special -> operation: divide

**Fabbyfil** · 01-21-2011, 10:48 AM

Hi

thnaks for the help and it seems to have made a different to the Date and Time part

25/07/1929 23:52:00
25/07/1929 23:53:00
25/07/1929 23:54:00
25/07/1929 23:55:00
25/07/1929 23:56:00
25/07/1929 23:57:00
25/07/1929 23:58:00
25/07/1929 23:59:00
26/07/1929 00:00:00
26/07/1929 00:01:00
26/07/1929 00:02:00
26/07/1929 00:03:00
26/07/1929 00:04:00

But it does look like the date is out obviously out of sync is there any way I could find out or make the date current ?

Thanks

**DonkeyOte** · 01-21-2011, 11:03 AM

I really don't understand the question I'm afraid... as you said you don't know what the start date should be.

Perhaps you could outline the "desired" results for your sample values.