I am using the below code to get the hours worked between the TimeIn and TimeOut and it works fine but if the shift starts in the PM and ends in the AM, it does not recognize the next day. For example if the start time is 8PM and ends at 1AM it gives me a total of 19 hours. It is takes the AM end time as the start time. Those fields are a date/time field. Any help would be appreciated. Thanks!
Total: (Abs(DateDiff("n",[TimeIn],[TimeOut])/60)))