I have the following formula defined that calculates the date difference in days and excludes weekends:
Local DateTimeVar d1 := (DateTimeValue ({EpisodeTests.DateAuth},{EpisodeTests.TimeAuth} ));
Local DateTimeVar d2 := (DateTimeValue ({Tracking.TrackDate},{Tracking.TrackTime} ));
DateDiff ("d", d1, d2) - DateDiff ("ww", d1, d2, crSaturday) - DateDiff ("ww", d1, d2, crSunday)
I need for the formula to include the time and the output shoud be in hours. I also need to exclude weekends.