I'm trying to find the difference between two dates in minutes. Unfortunately there is an issue with using the DateDiff function. One date is a login date which would be a current date and time. The second date is a system defined start of shift. Here is the problem, when a shift is created you enter the start time and end time of the shift i.e. 7am to 3:30pm. The system assigns a date to each entry of 12/31/1899 resulting in 12/31/1899 07:00:00. Which makes it unusable in the DateDiff function. I thought that perhaps I could extract the Hours and Minutes from each start time and then compare the result but I haven't been able to use one formula to extract the hours and minutes. Any ideas on this issue?
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.