Forum Discussion
Calculate time between opening hours
Hi. I would like to calculate time between opening hours and I would like to round it of to even 5 minutes. this also needs to consider dates, so the staring point is both date and time. The...
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.
Seeing these formulas I know I would have never solved this.
Thank you so much both of you!! Very grateful 🙂