How to calculate working time between two dates excluding holidays (Saturday, Sunday)?

Question

MySQL

Good afternoon!
Is it possible to calculate working time between two dates excluding holidays (Saturday, Sunday)?
By weekend I mean Saturday and Sunday. Holidays don't matter.
Working day from 9:00 to 18:00
I would like to get the result either in minutes or hours.
If we take approximate data, let's say date1 = 2017-01-26 12:00:00, date = 2017-01-30 12:00:00.
27.28 is Saturday and Sunday.
So the output should be in hours, for example:

| date 1             | date2               | buisness_time |
|2017-01-26 12:00:00 | 2017-01-31 15:00:00 | 9              |

Can this be implemented? So far, I only count through TIMESTAMPDIFF ...
Thanks in advance

Answer 1

It seems that I didn’t screw up, but there are more or less steps, so you can check: sqlfiddle.com/#!9/a6c585/115089
Working day boundaries are too lazy to add, but it’s not difficult.
At the same time, with a calendar it will be much easier and more versatile.