Hi, I need to calculate the duration of tasks within a shift minus the lunch and dinner breaks which are at set times, the issue I have is when the task starts after the end time of the break the answer is returned as a negative as seen in F3 in the attached sheet, thanks
Bookmarks