Hello Excel Forum Community,
I have looked through threads and not finding quite what I need for this calculation. I thought that the NETWORKDAYS function would help but I see that it just calculates for a certain hours as seen in this thread but my definition is a bit different. My working hours is set starting Monday at 8:00 and ending Friday at 18:00 and weekend hours start Friday 18:00 and go to Monday 8:00. I have attached a sample of what I'm looking for - any help is much appreciated.
Thank you for taking the time to read. Have a great day!
Bookmarks