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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
convert numeric value of total time to time 1
- Thread starter bspalmer
- Start date
-
1
- #2
synapsevampire
Programmer
Try:
whileprintingrecords;
stringvar TimeVal := //totext({table.field},2,""
;
left(TimeVal,instr(TimeVal,"."-1)
+
"."
+
totext((val(mid(TimeVal,instr(TimeVal,"."+1))*.6),0,""
-k
whileprintingrecords;
stringvar TimeVal := //totext({table.field},2,""
;left(TimeVal,instr(TimeVal,"."
-1)+
"."
+
totext((val(mid(TimeVal,instr(TimeVal,"."
+1))*.6),0,""-k
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question