I would like to calculate the difference between a scheduled off time and the actual off time. I would like to see a blank if the person actual got off early.
What seems pretty straightforward is complicated by the fact that some shifts occur over midnight.
I have attached a spreadsheet with an example along with my trys.
Thanks in advance
Walt
Bookmarks