Date / Time Manipulation
Posted: Wed May 12, 2010 5:34 am
Hi Chaps,
I have some basic code that takes a UNIX time, adds a pre-calulated duration, to give a 'due date/time'.
I then convert the UNIX time to [Y-m-d H:i:s] format for presentation.
The problem I'm having at the moment is that the due date/time can be something like 2010-05-12 23:55:10. This time is outside of normal working hours, I need to insure the due date/time falls between 09:00 - 17:30 (Mon-Fri).
So if the start time is: 16:00 and the duration is: 5 hours, firstly I need the time to 'carry over' to the next day, starting from 09:00, and secondly, if the next day is a weekend, carry over to the next working day. . . . .
Can anyone point me in the right direction?
Cheers
I have some basic code that takes a UNIX time, adds a pre-calulated duration, to give a 'due date/time'.
I then convert the UNIX time to [Y-m-d H:i:s] format for presentation.
The problem I'm having at the moment is that the due date/time can be something like 2010-05-12 23:55:10. This time is outside of normal working hours, I need to insure the due date/time falls between 09:00 - 17:30 (Mon-Fri).
So if the start time is: 16:00 and the duration is: 5 hours, firstly I need the time to 'carry over' to the next day, starting from 09:00, and secondly, if the next day is a weekend, carry over to the next working day. . . . .
Can anyone point me in the right direction?
Cheers