Cost * Time

[john hill]

I have produced a report that includes a field of amount of time by a person on a time sheet, the person has an hourly rate. i want to multiply the time spent by the hourly rate to end up with a total amount in curancy for the hours worked.

i.e. [Total Hours] (12:45) in time format * [HourRate] £22.50

i want to arrive at the field total of £280.12

Can anyone help please

 

[ColinEssex]

I make it that if someone works 12hrs 45mins then the cost at £22.50 per hour is £286.87p, not £280.12p

Col

 

[john hill]

Yes my Mistake

So how do i arrive with the formula to get the correct amount in curancy?

 

[Brianwarnock]

I don't know how you arrived at the time and if you could have calculated the cost in the query that generated the reort but having arrived at the situation of having a time which needs to be decimalised to do the calc try something like

=sum((DateDiff("n",#00:00:00#,[Total Hours])/60)*[hourrate])

Brian

 

[ColinEssex]

You can put this in a query

CCur((Format([YourTimeField],"h")*60+Format([YourTimeField],"n"))*37.5/100)

Basically you change the time into minutes and then multiply the time by 37.5p (cost per minute)

Col