how can I display the date from a number of seconds given?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lady Lexly - 11 May 2005 17:20 GMT

As the expression: =Format(Now(), "y") displays the number of the day of the
year the current date represents, where y is 1 through 366.... I need the
antonym funtion of this, in order to get a date from a specific number of
seconds given.
Could somebody help me on this matter?
Thanks in advance for your help

Reply to this Message

Rick B - 11 May 2005 19:31 GMT

A date from a number of seconds given? Huh?

If I tell you "120 seconds", what date would you expect to see?

I don't understand the question.

Signature

Rick B

> As the expression: =Format(Now(), "y") displays the number of the day of the
> year the current date represents, where y is 1 through 366.... I need the
> antonym funtion of this, in order to get a date from a specific number of
> seconds given.
> Could somebody help me on this matter?
> Thanks in advance for your help

Reply to this Message

Rick B - 11 May 2005 19:40 GMT

Aha! sounds like you want to know the number of seconds from the beginning
of the year. It seems to me that there are 86,400 seconds in a day, so take
whatever they give you and divide by 86,400. That will give you the number
of days. I am still not sure how to return a DATE though. Since I am not
sure where your starting point would be.

Signature

Rick B

Reply to this Message