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 Rhinorhino 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
Joined
Mar 12, 2001
Messages
31
Location
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

Corinne30
  • Locked
  • Question Question
Running total based on beginning parameter value
Replies
0
Views
363
Corinne30
Corinne30
Corinne30
  • Locked
  • Question Question
Running total based on beginning parameter value
Replies
0
Views
366
Corinne30
Corinne30
D
  • Locked
  • Question Question
Running total from a subreport only showing last value
Replies
4
Views
1K
doodledump
D
POrlowski
  • Locked
  • Question Question
Calculating Sick Time
Replies
7
Views
888
POrlowski
POrlowski
jlr123
  • Locked
  • Question Question
Crystal Formula Grand Total - Running total
Replies
2
Views
502
jlr123
jlr123

Part and Inventory Search

Sponsor

Back
Top