Multiplying hours by a dollar value to get a total

[kcmiuser]

On a small project, I am tracking elapsed time for projects, I had everything functioning well and delivered the report. Now I have it back and the person who wanted it wants to add cost, my issues is multiplying the hourly rate times the elapsed time (hours:minutes), the question is can I do this directly on a detail line in the master report? I am not very well-versed in creating functions like this.

[ranman256]

Build a query, bring down the fields you need, then add a calculated field by entering the fields in a blank column:
[ElapsedTime]*[rate]

you can rename the label in front of the calculation colon
Cost: [ElapsedTime]*[rate]

[kcmiuser]

Build a query, bring down the fields you need, then add a calculated field by entering the fields in a blank column:
[ElapsedTime]*[rate]

you can rename the label in front of the calculation colon
Cost: [ElapsedTime]*[rate]

I see I need to clarify this a bit more. I am getting the fields for the report from a make table query which has the elapsed time in calculated filed, but it is in minutes. On the report, I am converting the minutes to hours:minutes using a text field with this function - =[Minutes]\60 & Format([Minutes] Mod 60,"\:00"). should I have done this in the query in order to be able to add costing?

[ranman256]

Yes, but you should never put calculated fields in a table. They should always be 'calculated' live in a query. ( But you can do it in the make table too. )

[kcmiuser]

Yes, but you should never put calculated fields in a table. They should always be 'calculated' live in a query. ( But you can do it in the make table too. )

OK, thanks. Now, I have the elapsed time field in the query as minutes and I have the field with the per hour cost in the same query, how would I create a calculated field that would give me the correct amount for the minutes worked, I am unsure how to multiply an elapsed time field (minutes) by a rate (hourly). do change the minutes to hh:mm or change the value of rate to per minute? Very unsure.