Date Diff to calculate hours.

[rywello]

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)))

[ranman256]

The timeIn/out fields sshould hold BOTH date and time for this very reason.

5\1\2018 4:00 pm
you don't want date in 1 field and time in another.

[rywello]

Both of the fields are date/time with the General Date format but only the time shows.

[ArviLaanemets]

Format one of your datetime fields (TimeIn/TimeOut) as double temporarily. When the field values are <1, then you have only time part without date info. It depends on regional settings, but with some formats only time part is saved to field. I'm not entirely sure, but I have the feeling that when I last time encountered such behavior, I tried to use General Time format. Use Custom format instead.

[Micron]

Possibly your dates are not in US format? this ought to work

Abs(DateDiff("n",#05/30/2018 08:00:00 pm#,#05/31/2018 01:00:00 am#)/60)