Hours between time stamps

[Misca]

This one's a slightly tricky one (to me at least):

I've got two time stamps and I should calculate the difference between in hours. In theory that's not that hard at all but what makes it tricky is they usually have different dates and I should only count the hours from the working days (excluding weekends & holidays). The networkdays-function helps a lot but causes a lot of problems as well because it seems to count each working day as a full date.

I believe I can solve this myself but the end result is not going to be pretty nor straight forward. I bet there must be a simpler solution to this problem but I just can't figure it out.

The time calculation always starts at noon two workdays after the actual time stamp and ends whenever the next time stamp is. If the end time stamp happens to be before the first one the difference is supposed to be minus hours.

 

[DRSteele]

Your problem is a common one. Calculating net working hours for personnel in shift-work is notoriously difficult. If only there were a native Excel function that would accomplish this, it would make life easier. There are threads in this forum dealing with it, like here. https://www.mrexcel.com/forum/excel-questions/950119-total-hours-call-over-holidays-shifts.html

I urge you to got to Excel User Voice, sign up and vote for this function to be created by the MS Excel team. The suggestion been there for a while, and I don't know why more people don't vote for it. https://excel.uservoice.com/forums/...0730205-create-networkhours-as-a-new-function