Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Converting Time...
- Thread starter kovas
- Start date
synapsevampire
Programmer
Try:
whileprintingrecords;
numberVar dur := ({MyTable.MyHours}*60)*60
numberVar hrs;
numberVar min;
numberVar sec;
stringVar hhmmss;
hrs := Truncate(Truncate(dur/60)/60);
min := Remainder(Truncate(dur/60),60);
sec := Remainder(dur,60);
hhmmss := totext(hrs, "0"
+ ":" + totext(min, "00" + ":" + totext(sec, "00"
hhmmss
-k kai@informeddatadecisions.com
whileprintingrecords;
numberVar dur := ({MyTable.MyHours}*60)*60
numberVar hrs;
numberVar min;
numberVar sec;
stringVar hhmmss;
hrs := Truncate(Truncate(dur/60)/60);
min := Remainder(Truncate(dur/60),60);
sec := Remainder(dur,60);
hhmmss := totext(hrs, "0"
+ ":" + totext(min, "00" + ":" + totext(sec, "00"hhmmss
-k kai@informeddatadecisions.com
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question