Days, Hours and minutes

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

@Homeonthecouch - 22 Jul 2007 10:45 GMT

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

Reply to this Message

Bob Phillips - 22 Jul 2007 12:38 GMT

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

Signature

---
HTH

Bob

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

> Hello,
>
[quoted text clipped - 11 lines]
>
> Andrew

Reply to this Message

@Homeonthecouch - 22 Jul 2007 14:14 GMT

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

> Try dividing by 86400 and formatting as dd/mm/yyy hh:mm:ss
>
[quoted text clipped - 13 lines]
>>
>> Andrew

Reply to this Message

Bob Phillips - 22 Jul 2007 14:50 GMT

Sounds like UNIX time, so you just use

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

Signature

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
[quoted text clipped - 22 lines]
>>>
>>> Andrew

Reply to this Message