Hi all,
I've seen this posted about more than once, but I still haven't been able to solve my particular issue.
I have a query called qryRelEventEmployee, which has the column WkHrs that is calculating how many hours worked in a shift by using DateDiff("n",[StartTime],[EndTime])/60 - all works great until the shift passes midnight, then I get negative times as a result.
I've see that =IIf([End Time]>[Start Time],[End Time]-[Start Time],([End Time]+1)-[StartTime]) may be an option, but when I replace my "DateDiff..." with that "IIf" statement, everything stops calculating.
How might I solve this?
Thank you.
I've seen this posted about more than once, but I still haven't been able to solve my particular issue.
I have a query called qryRelEventEmployee, which has the column WkHrs that is calculating how many hours worked in a shift by using DateDiff("n",[StartTime],[EndTime])/60 - all works great until the shift passes midnight, then I get negative times as a result.
I've see that =IIf([End Time]>[Start Time],[End Time]-[Start Time],([End Time]+1)-[StartTime]) may be an option, but when I replace my "DateDiff..." with that "IIf" statement, everything stops calculating.
How might I solve this?
Thank you.