Solved

How to find a rate

Posted on 2011-09-13
6
373 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 35

Expert Comment

by:johnsone
ID: 36532390
The rate should be:

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

0
 
LVL 35

Expert Comment

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

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

Expert Comment

by:mlmcc
ID: 36532463
Or just

  (dur/3660) * 41.56

mlmcc
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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 55

Expert Comment

by:Huseyin KAHRAMAN
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 101

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 35

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

Enroll in June's Course of the Month

June’s Course of the Month is now available! Experts Exchange’s Premium Members, Team Accounts, and Qualified Experts have access to a complimentary course each month as part of their membership—an extra way to sharpen your skills and increase training.

Question has a verified solution.

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

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
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…
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

688 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