Days, Hours and minutes

@

@Homeonthecouch

Hello,

I currently have a lump of data that is reporting back to me a 10 digit
number.
I have no idea where the number started (When) but I do know that the
increments are in seconds.

If I can set a point that I know to be a time I know say, 10:30am, how can I
work out the other data stamps I have?
I would like the 10 digit data to be converted to date and time if possible.

Does that make any sense to anyone?

Andrew
 
B

Bob Phillips

Try dividing by 86400 and formatting as dd/mm/yyy hh:mm:ss


--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
@

@Homeonthecouch

Yeah I worked it out just after I posted the question.
That might have worked apart from the start date/time appears to be
01/01/1970
Lots of calculations later I got it to report a value I understand.

Thanks for the help though much appreciated.

Andrew
 
B

Bob Phillips

Sounds like UNIX time, so you just use

=DATE(1970,1,1)+A1/60/60/24

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Top