Time in calculated field for shifts going past midnight

Jul 28, 2015
Reaction score
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.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question