Multiply time by currency

[greymonkey]

Hi there,

I have a running sum in the report totalling up the hours and a field with a currency value (hourly pay)

The trouble I am having is multiplying the hours by the pay.

Any ideas

 

[jrbarnett]

Hi,

Use a textbox

=Hour(Timefield)*[Hourly Pay]

will give you the total number of hours worked.
If you need to pro rata it for extra minutes, use:

=(Hour(Timefield)*[Hourly Pay])+(minute(timefield)/60)*[Hourly Pay]

John

 

[dhookom]

GreyMonkey,
THis depends on how you are storing the hours worked. If you stored it as numeric rather than date/time (good practice) then all you should have to do is:
=[HoursWorked] * [Hourly Pay]
To sum these in a report, you need to use:
=Sum([HoursWorked] * [Hourly Pay])


Duane
MS Access MVP
Find out how to get great answers faq219-2884.