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 seconds to long time return DaSecs end Sec2Standard 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 includes the AM/PM bit, we must needs find a different way to do it if we don't want to deal with AM/PM. Fortunately, the dateItems time/date format gives you everything you need on a silver platter, or at least in a comma-delimited list whose individual parts you can access thru "item X of TheTime". To a second approximation: function Sec2Standard DaSecs convert DaSecs from seconds to dateItems return item 4 of DaSecs & ":" & item 5 of DaSecs & ":" & item 6 of DaSecs end Sec2Standard No AM/PM here, thanks. However, it's worth noting that dateItems believes in a 24-hour clock; if you send this function the number of seconds corresponding to "10:53:12 PM", it will spit out the result "22:53:12". Could this be a problem for what you're doing? I dunno, but fortunately, it's not difficult to translate a 24-hour *hour* into a 12-hour *hour*, you should pardon the expression. To a third approximation: function Sec2Standard DaSecs convert DaSecs from seconds to dateItems # mind the line wrap here... return ((((item 4 of DaSecs) - 1) mod 12) + 1) & ":" & item 5 of DaSecs & ":" & item 6 of DaSecs end Sec2Standard There: Whether the number of seconds you send this puppy corresponds to "10:53:12 PM" or "10:53:12", this function *will* give "10:53:12" right back to you. Hope this helps... _______________________________________________ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
