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!

Register Log in
  • 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

Status
Not open for further replies.
bspalmer

bspalmer

MIS
Jan 16, 2003
14
US
How would I convert the numeric value of total time to a time value. Example: I have a total time value of 1.69, how do I convert that to show 1hr 41min.
 
Sort by date Sort by votes
Try:

whileprintingrecords;
stringvar TimeVal := //totext({table.field},2,"");
left(TimeVal,instr(TimeVal,".")-1)
+
"."
+
totext((val(mid(TimeVal,instr(TimeVal,".")+1))*.6),0,"")

-k
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

D
  • Locked
  • Question
Running total from a subreport only showing last value
Replies
4
Views
386
doodledump
D
POrlowski
  • Locked
  • Question
Calculating Sick Time
Replies
7
Views
207
POrlowski
POrlowski
Corinne30
  • Locked
  • Question
Division of currency formula with/without rounding
Replies
7
Views
490
dgillz
dgillz
jlr123
  • Locked
  • Question
Crystal Formula Grand Total - Running total 1
Replies
2
Views
117
jlr123
jlr123
BradCustom
  • Locked
  • Question
Need help with setting a value to 0
Replies
0
Views
100
BradCustom
BradCustom

Part and Inventory Search

Sponsor

Back
Top