Calculated Fields (1 Viewer)

[sush]

Hi,

I have a small problem.

I have a start time and finish time each having a field data type of Date/Time (Short Time) and a calculated field which shows the number of hours/mins between the two which is also a Short date field, the control source for this field is a running total.

Hence i have : Start Time : 09:00
finish Time: 18:00
Hours/Mins : 09.00
Now i have a drop down list which is a rate (currency Field) this is a linked table which stores the information which is multiplied by the number of hours to give a line total which is a currency field and which is a running total.


Hence i have : Start Time : 09:00
finish Time: 18:00
Hours/Mins : 09.00

Rate : £12.00

Total: £108.00

When i perform this calculation i get a figure which makes no sense to me. if i use all number fields and no drop down for the rates the calculation works fine.

Can any body help

Thank You

 

[JINKS]

change the calculated field to:

[hours/minute]*24*[hourly rate]

That should sort it out.