Calculating Hourly Pay Rate

[mudraker]

Via a form I update an Access 2003 database (http://vbaexpress.com/forum/) with various information


The database & form has a field for the length of time a task took to complete. The entry is in h:mm format (http://vbaexpress.com/forum/)

Also another field for the payment amount of the completed task in $.cc format.

After the above fields have been filled, I need to populate a 3rd field with the hourly pay rate for the completed task.

The length of time a task takes & the total payment paid various with each task.

How do I calculate the hourly pay rate

The time taken is in a Textbox named tbRouteTime
The Payment amount is in a Textbox named tbValue
The Hourly pay rate goes into a Textbox named tbHourRate

Thanks in Advance for your assistance

I posted this question at ozgrid 24 hours ago & have not yet had any replies

http://www.ozgrid.com/forum/showthread.php?t=72554

[asingh]

Hi,

You want to multiply time from tbRoutetime to payment from tbValue and show it in tbHourRate...??

Is the data coming from a table..or is just manual field.

Would you want the final calculate output saved to a table....??

regards,

asingh

[OBP]

asingh, I think the user wants to divide the Payment Amount (Total) by the Hours Taken to get the Hourly Rate.

[mudraker]

Most of the data is manually entered into the form.

The entry in tbRoutetime is entered manually example 2:30

The entry in tbValue entered by a macro that calculates the total value based on data manually entered into 2 fields. The macro is run using an After Update macro.

To get the hourly rate I beleive I need to use something like

tbHourRate = tbValue / tbRouteTime

But I can not get this to produce a correct $ value.

As the above data is in a text box do I need to add some other code to convert them to a numeric value that will calculate correctly?

[mudraker]

Problem solved via reply on other site

[Tom]

Maybe:
Payrate/(2080*FTE)