Hours to Pay

[normie]

I have two tables I want to query to come up with an employees pay
The first table has a "hh:mm:ss" format and the other has a "currency" format
I want to query the two tables (10:42:02 * $18.00)
but cannot get the $ amount correct am I missing a step?

[azhar2006]

in format $#,##0.00;($#,##0.00)
And in decimal places ..... 2

[azhar2006]

For example, you could use the following custom Currency format:
$#,##0.00[Green];($#,##0.00)[Red];"Zero";"Null"
This number format contains four sections separated by semicolons and uses a different format for each section

[normie]

I am still gettting the wrong total
HOURS = 19:58 (Short Time) * RATE = $18.00
the sum in the query is $17.78

[pbaldy]

Time is stored as a fraction, where 12 hours is .5. Try multiplying your time value by 24 to get it into hours.

[June7]

Setting the format property of a field or control does not change the actual value. Using Format function converts to a string. If you want to multiply with time part of a data/time value, convert it to decimal.

x represents your field

(CDbl(x)-Int(x)) * 18