Solved

How to find a rate

Posted on 2011-09-13
6
370 Views
Last Modified: 2012-05-12
How can I find a numerical value this equation to be multiplied by another number ($41.56/hour)

In the equation below I return a time. I then want to take that time and multiply it by (41.56) and get my result to again multiple by a number

How can I do this?

Shared NumberVar scrapped_Time;
numberVar dur := scrapped_Time;
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");

Open in new window

0
Comment
Question by:cmdolcet
6 Comments
 
LVL 34

Expert Comment

by:johnsone
ID: 36532390
The rate should be:

(hrs*41.56) + ((min/60)*41.56) + ((sec/3600)*4156)

0
 
LVL 34

Expert Comment

by:johnsone
ID: 36532394
Sorry, missed a decimal place:

(hrs*41.56) + ((min/60)*41.56) + ((sec/3600)*41.56)
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 36532463
Or just

  (dur/3660) * 41.56

mlmcc
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
LVL 51

Expert Comment

by:HainKurt
ID: 36532504
"I return a time" --> I guess you are returning a text like "2:34:56"

create a function to convert this to number

first split it by ":", then convert each piece to numeric, convert each piece to hour

numberVar v = (int)split("2:34:56",":")[0] + (int)split("2:34:56",":")[1]/60 + (int)split("2:34:56",":")[2]/(60*60)

and use this function to convert your time (actually string) into numerical values...

float Convert2Num(t) {
  the logic above, and return numeric value
}


Convert2Num("2:34:56") = 2.5822
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 125 total points
ID: 36532974
Change your formula to
Name - YourFormula
Shared NumberVar scrapped_Time;
numberVar dur := scrapped_Time;
numberVar hrs;
numberVar min;
numberVar sec;
stringVar hhmmss;
numbervar amount;

amount := dur / 3600 * 41.56;
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");


Add another formula to display the value calculated
EvaluateAFter({@YourFormula});
numbervar amount;
amount

mlmcc
0
 
LVL 34

Expert Comment

by:James0628
ID: 36538784
Or, since you've already got the time in scrapped_Time, you could just use that.  Create a formula like this and put it in the same section as the formula that you posted.

Shared NumberVar scrapped_Time;
scrapped_Time / 3600 * 41.56


 If you also want to use that value for something else, you'll need another formula and/or variable.  It depends on what you want to do with it.

 James
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Pictures In Crystal 10 55
Break apart and rearrange field, Crystal Reports 9 74
Use data from .txt file into Crystal reports 9 64
Crystal report highlighting 5 46
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

827 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question