seconds to HHHH:MM:S

[vincer]

Hello,
is there a simple way of converting a number of seconds to
it's HHHH:MM:SS equivalent without using a formula?

thanks
Vince

 

[Ngolem]

You are going to need a "formula" even if there is a simple function to do the job

WhilePrintingRecords
numbervar theHours;
numbervar theMins;
numbervar theSecs;

theSecs := Remainder ({Table.fieldSecs},60);
theMins := Remainder(truncate({Table.fieldSecs}/60),60);
theHours := truncate(truncate({Table.fieldSecs}/60)/60);

totext(theHours,"####&quot + ":" + totext(theMins,"00&quot + ":" + totext(theSecs,"00"

this will do the job.

JimBroadbent@Hotmail.com

 

[vincer]

Thanks for that

 

[John43]

Check under additional functions. There are a few
choices for display and format of hhmmss.
uflssm.dll is what you should check to be sure it
is installed on your machine. If not you can download
from Crystal Decisions website.
Once installed all you need to do is select the
format you like.