how to multiply hoursAndMinutes i.e 9:30 by pay rate $7.5

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I developed time sheet with workeddate, timein, and timeout, I use the
HoursAndMinutes=([timeout]-[timein]) to get Hoursworked which it works fine,
and when I use the result ie workedhours in this form 9:30 to multiply it by
PayRate i.e =[workedhours]*[PayRate] it does not work it keeps give me and
error
 
Try something like this:
DateDiff("n", [timein], [timeout]) * [PayRate] / 60

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

message
news:[email protected]...
 
Are you trying to multiply by nine and one-half hours, if so you need to use
the decimal equivalent of 9.5-try that and see if it accepts that.

Allen Browne said:
Try something like this:
DateDiff("n", [timein], [timeout]) * [PayRate] / 60

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

message
I developed time sheet with workeddate, timein, and timeout, I use the
HoursAndMinutes=([timeout]-[timein]) to get Hoursworked which it works
fine,
and when I use the result ie workedhours in this form 9:30 to multiply it
by
PayRate i.e =[workedhours]*[PayRate] it does not work it keeps give me and
error
Click to expand...
Click to expand...
 
Back
Top