DateDiff giving negative result when the next date-time is less than 24 hrs difference
This is for a calculated column. Whenever the [exit time] is the next day, but within 24 hours of [enter time], I get a negative result for minutes. All other aspects, except this, are working fine. Minutes = VAR _NonWorkingDays = CALCULATE( COUNTROWS('Calendar'), 'Calendar'[Day Type] <> "Work Day" ) VAR _WorkTimeElapsed = DATEDIFF(AuditLog[Enter_Time],AuditLog[Exit_Time], MINUTE) - (_NonWorkingDays* 24 * 60) RETURN _WorkTimeElapsed
