for example: I have 3601 seconds in integer, I want to convert it into 01:00:01
string format.

can anyone show me a function to get this done?

thanks.

06-07-2002, 11:56 AM

GunPaq

Re: How to convert seconds to hh:mm:ss format?

Try:

DateAdd("s", 3601, #12:00am#)

Steve.

"convert" <zhang5gor@yahoo.com> wrote in message
news:3d00bf0a$1@10.1.10.29...
>
> Hi guys,
>
> I'v got this problem: How to convert seconds into hh:mm:ss format?
>
> for example: I have 3601 seconds in integer, I want to convert it into
01:00:01
> string format.
>
> can anyone show me a function to get this done?
>
> thanks.
>

06-07-2002, 12:00 PM

GunPaq

Re: How to convert seconds to hh:mm:ss format?

If you actually want a string then use the Format function on the result.