Forum Discussion
Calculate time between opening hours
Thank you for this, but I'm sorry, I still can't get it to work. I understand the different parts but not how to put them together.
But what I wan't is the end time based on 35 hours from the starting time.
So lets say I write 2020-02-27 11:00 and want to add 35 hours and get a time and a date when the 35 hours will end.
So, not counting the closed hours and not counting the weekend.
I want the answer to be 2020-03-04 12:00 (if I'm not mistaken 🙂 )
fresope545 The attached workbook has a working example of the required formula in it. I tested it thoroughly and sincerely hope that I didn't miss anything. In order to keep the formula reasonably clear, I chose to use some helper formulae. The model is dynamic and allows you to set the opening and closing time and the number of hours you want to jump ahead.
Thank you, Savia , for pointing out how to round time to 5 minutes.