Days, Hours and minutes

  • Thread starter Thread starter @Homeonthecouch
  • Start date Start date
@

@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
 
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)
 
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
 
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)
 
Back
Top