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...
Hello Riny.
So mit turns out I made a big mistake 🙂
The date & time I was going to calculate from was not the starting date/time. It was the end date/time and I need to deduct from that end date to end up with the starting date.
So therefore i wonder if you could help me once again. I have tried but unfortunatelly this is a bit over my head.
Also, the time you decuct might not be full hours, it could be for example 17:40.
Any chance you can help me?
Best regards Fredrik
fresope545 Perhaps the attached file does what you need.
Enter the number of hours you want to deduct in a time format. For instance, 35 hours would be 35:00. 17 hours and 40 minutes would be 17:40. No need for a minus in front of it.