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

[moddathir alklus]

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

 

[Allen Browne]

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]...

 

[Mary P. Bordelon]

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.

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