RE: seconds to standard time numberformat?

2003-08-24 Thread Monte Goulding
> > > > Hi > > > > You've had quite a number of solutions but here's > > another one: > > > > -- function to return the the time format (h:mm:ss) > > from an input in seconds > > function timeFormat timeInSecs > > if timeInSecs = 0 then > > put "0:00:00" into timeInForm > > else > > pu

RE: seconds to standard time numberformat?

2003-08-22 Thread Jan Schenkel
--- Monte Goulding <[EMAIL PROTECTED]> wrote: > > Hi > > You've had quite a number of solutions but here's > another one: > > -- function to return the the time format (h:mm:ss) > from an input in seconds > function timeFormat timeInSecs > if timeInSecs = 0 then > put "0:00:00" into timeIn

Re: seconds to standard time numberformat?

2003-08-22 Thread J. Landman Gay
On 8/22/03 12:45 PM, [EMAIL PROTECTED] wrote: This will give you results like "10:53:12 PM" -- that is, you'll get the hour, minute, second *and* whether it's AM or PM. Of course, your original question didn't mention the AM/PM bit at all; since the "long time" time format automatically incl

Re: seconds to standard time numberformat?

2003-08-22 Thread Mark Swindell
Cubist, Thanks for the tutorial on date/time conversion! You should send this to the tips section of Runrev. In fact, the PM was displaying in my scenario I posted a few minutes ago, but my field was too small to show it. My use is for short timed practice tests, so it's not appropriate to

Re: seconds to standard time numberformat?

2003-08-22 Thread Mark Swindell
Thanks for the speedy responses! Much appreciated. This snippet displays what I wanted. on upDateTimer global gtheSecs,gtheSecsLong add 1 to gtheSecs put gtheSecs into gtheSecsLong convert gtheSecsLong to long time put empty into char 1 to 2 of gtheSecsLong -- removes init

Re: seconds to standard time numberformat?

2003-08-22 Thread Cubist
sez [EMAIL PROTECTED]: >Is there a numberformat or other option that will display seconds in >standard 00:00:00 format? The CONVERT function is your friend for all things related to display of time and/or dates. To a first approximation: function Sec2Standard DaSecs convert DaSecs from sec

Re: seconds to standard time numberformat?

2003-08-22 Thread Ken Ray
g them together with ":"s. Ken Ray Sons of Thunder Software Email: [EMAIL PROTECTED] Web Site: http://www.sonsothunder.com/ > From: Mark Swindell <[EMAIL PROTECTED]> > Reply-To: [EMAIL PROTECTED] > Date: Fri, 22 Aug 2003 07:35:33 -0700 > To: [EMAIL PRO

Re: seconds to standard time numberformat?

2003-08-22 Thread J. Landman Gay
On 8/22/03 9:35 AM, Mark Swindell wrote: Is there a numberformat or other option that will display seconds in standard 00:00:00 format? get the seconds convert it to long time put it -- Jacqueline Landman Gay | [EMAIL PROTECTED] HyperActive Software | http://www.hyperact

seconds to standard time numberformat?

2003-08-22 Thread Mark Swindell
Is there a numberformat or other option that will display seconds in standard 00:00:00 format? I've got a "send to me in 1 second...add 1 to field theTime" scenario going on a project, and would like the result to display in standard form, rather than raw seconds. What's the most efficient way