|go ahead... be a heretic
Work Roster Calcuationby Smaug (Pilgrim)
|on Jun 02, 2008 at 09:16 UTC
Smaug has asked for the wisdom of the Perl Monks concerning the following question:
I have been out of this for some time and I'm now trying yet again to brush off the rust and get back to some coding, so please be patient.....
I need to be able to do some date arithmetic for a work roster. For this I would like to convert a series of dates into Unix Time so that I can easily add and subtract. The problem is the format I'm given the information as shown below:
What this means is all the hours from Monday to Friday between 07:00 and 18:00. (note: it could also read 7:00 AM - 6:00 PM)
Dates without times specified are holidays where no work is done.
So effectively I need to calculate the amount of working hours taken to complete a task which may take 3 weeks, but only include or exclude the hours as shown above.
I have looked at Date::Manip, but it has numerous warnings stating, "be sure that you REALLY need to use this module".
Should I be looking at something else?
Peddle faster monkeys!! I need more power!!