Calculating pay based on start and end time

[Edmund Wong]

I use Allen Browne's formula, PayAmount: Round(CCur(Nz(DateDiff("n",
[StartDateTime], [EndDateTime]) * [HourlyRate] / 60, 0)), 2) to
compute pay. But I'm having a difficult time when someone works from,
say, 9:00pm to 2:00 am. I get the wrong values. How do I compute time
from when it crosses midnight?

Thanks for any help

 

[Douglas J. Steele]

It sounds as though you're strictly using Time. In my opinion, you should
also have the Date there. Then you won't have any problem.

If you can't do that, see whether
http://www.mvps.org/access/datetime/date0008.htm helps.