calculate rate * hours worked

[hamish mather]

Please Can Someone help me

I have the folowing fields StartTime, EndTime, HourlyRate, in a table
HoursWorked: Format([StartTime]-1-[EndTime],"Short Time")

So Know I need HourlyRate*HoursWorked gives me error

StartTime 23:00 EndTime 10:00 = 12hours worked

PayAmount: Round(CCur(Nz(DateDiff("n",[StartTime],[EndTime])*[HourlyRate]/60,0)),2) this works but gives negative value

[hertfordkc]

Reverse start time & end time. Bet you have already fixed it.