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