Time and Money Calc

[Dr. Evil]

Hello, I need help with this convertion number calculation.

I need calculaion to:

rate x time = total

I do not know how to work the time field with the number field.

I have attached a sample file with involved fields built. Take a look if you think it will help with my question.

THANKS!!!!

[-Queue-]

You need to convert the time field to a decimal representation. Try using

num_rate * (Hour(time_quote) + Minute(time_quote) / 60 )

for your clc_quote field.

[Slobey]

Do you want your time field to be a time of day or the number of hours worked. If you want the hours worked, you shouldn't use a time field but a number field. If you want a time of day, you need a start time and a finish time and then a calc to determine the hours.

[comment]

Assuming we are talking about rate per hour, try:

time * rate / 3600

[Dr. Evil]

THANK YOU Everyone!

In the real database I'm building it is a little more complicated then the attached sample. So... all the suggestions helped very much in the different ways i needed to use the data.

Keep on ROCKIN!