Need to convert a number to a time

[MisterrMac]

I'm new to using Crystal but I thought this wouldn't be such a difficult task:
I am pulling open duration information from Help Desk Tickets to calculate how much time each person is spending on them over a given range of days. Each instance is in seconds and a grand total, also seconds, is displayed at the end of each user listing. Now I want to convert that into an HH:MM:SS format and show it on the report. How would I formulate that?

Any Help is appreciated?!

 

[Ngolem]

no problem

one hour has 60 * 60 = 3600 secs

@convertToTime

WhilePrintingRecords;
numberVar testHours;
numberVar testMins;
numberVar testSecs;

testHours := truncate({Table.seconds)/3600)
testMins := truncate((({Table.seconds)/3600) - testHours)*60)
testSecs := truncate((((({Table.seconds)/3600) - testHours)*60) - testMins)*60)

totext(Time(testHours,testMins,testSecs),"hh:mm:ss&quot
Jim Broadbent

 

[synapsevampire]

I use the following formula:

WhilePrintingRecords;

numberVar dur;
numberVar hrs;
numberVar min;
numberVar sec;
stringVar hhmmss;

dur := {MyTable.MyDuration}

hrs := Truncate(Truncate(dur/60)/60);
min := Remainder(Truncate(dur/60),60);
sec := Remainder(dur,60);

hhmmss := totext(hrs, "0&quot + ":" + totext(min, "00&quot + ":" + totext(sec, "00"

hhmmss

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[MisterrMac]

Great Quick answers! Thanks!