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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Total Time Taken

Status
Not open for further replies.
zircom

zircom

IS-IT--Management
Mar 12, 2001
31
GB
I have a string field hh:mm which I want to calculate total time taken (total hours spent travelling during workind day)for each member of a workforce
 
Sort by date Sort by votes
I would convert the each string value into minutes then subtract to get the result;

@calcMinutes

WhilePrintingRecords;
numberVar totalMinutes;

totalMinutes := tonumber(left({table.timevalue},2) * 60 +
tonumber(right({table.timevalue},2)
totalMinutes;
Jim

JimBroadbent@Hotmail.com
 
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
509
doodledump
D
POrlowski
  • Locked
  • Question
Calculating Sick Time
Replies
7
Views
304
POrlowski
POrlowski
jlr123
  • Locked
  • Question
Crystal Formula Grand Total - Running total 1
Replies
2
Views
170
jlr123
jlr123
Paulo R
  • Locked
  • Question
CR Running Total distinct count duplicates
Replies
9
Views
275
Paulo R
Paulo R
BradCustom
  • Locked
  • Question
Running total on variable 1
Replies
3
Views
163
BradCustom
BradCustom

Part and Inventory Search

Sponsor

Back
Top