I need a PHP array at the end based on the following information.
$startDateTime = "2024-01-06 14:00:00";
$endDateTime = "2024-01-13 14:00:00";
However, the working hours from
Monday to Friday 9:00 a.m. to 6:00 p.m.
and
Saturday 9:00 a.m. to 2:00 p.m.
should be taken into account.
My output as a PHP array should look like this (Date => Minutes – but only in Working hours):
Array
(
[2024-01-06] => 0
[2024-01-07] => 0
[2024-01-08] => 540
[2024-01-09] => 540
[2024-01-10] => 540
[2024-01-11] => 540
[2024-01-12] => 540
[2024-01-13] => 300
)
For explanation:
06 January 2024 is a Saturday and the appointment starts after work ends.
From 2024-01-07 to 2024-01-12 he works the full 9 hours every day. January 2024, 13 is again a Saturday and 5 hours are part of the working time.
I would be very happy about a solution.
I’ve tried a lot, but can’t find a correct solution in PHP.