A97 - how to format time lapse to appear as "4-minutes 12-seconds"?

I have a procedure that runs. It takes 3-5 minutes generally.

I would like to display the timelapse at the end of the process.

I would like the approximate timelapse value of 0.002141 to be
displayed as 3-minutes 5-seconds. How do I do that with the
Format$ command in VBA?

I tried Format$(0.002141,"n-minutes s-seconds") but that did
not work at all.

re: A97 - how to format time lapse to appear as "4-minutes 12-seconds"?

Hi,
[color=blue]
> I would like to display the timelapse at the end of the process.
>
> I would like the approximate timelapse value of 0.002141 to be
> displayed as 3-minutes 5-seconds. How do I do that with the
> Format$ command in VBA?
>
> I tried Format$(0.002141,"n-minutes s-seconds") but that did
> not work at all.[/color]

Try:
Format$(0.002141,"nn") & "-minutes " & Format$(0.002141,"ss") & "-seconds"

Jens

re: A97 - how to format time lapse to appear as "4-minutes 12-seconds"?

That was it. Thx, jens.
xxxxxxxxxxxxxxxxxxxxxx
[color=blue]
>Try:
>Format$(0.002141,"nn") & "-minutes " & Format$(0.002141,"ss") & "-seconds"
>
>Jens
>[/color]

re: A97 - how to format time lapse to appear as "4-minutes 12-seconds"?

You meant

Format$(0.002141,"n\-\m\i\n\u\t\e\s s\-\s\e\c\o\n\d\s")

3-minutes 5-seconds

(david)

"MLH" <CRCI@NorthState.net> wrote in message
news:jgjrh1ptcuuh5qh29j2vnj2iojodqrpcaa@4ax.com...[color=blue]
>I have a procedure that runs. It takes 3-5 minutes generally.
>
> I would like to display the timelapse at the end of the process.
>
> I would like the approximate timelapse value of 0.002141 to be
> displayed as 3-minutes 5-seconds. How do I do that with the
> Format$ command in VBA?
>
> I tried Format$(0.002141,"n-minutes s-seconds") but that did
> not work at all.[/color]

re: A97 - how to format time lapse to appear as "4-minutes 12-seconds"?

Hey, I like that too! Thx.
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

[color=blue]
>You meant
>
>Format$(0.002141,"n\-\m\i\n\u\t\e\s s\-\s\e\c\o\n\d\s")
>
>3-minutes 5-seconds
>
>(david)
>[/color]