How about a question for the FAQ? http://perlmonks.org/index.pl?node_id=298788 > > Calculate down time of devices in prime time (only working hours, excluding > p_holidays) > by albertc on Oct 13, 2003 at 05:00 GMT+3 > > I have up & down datetime data for devices, I need a function that will provide the > downtime within the primetime period. Input will be d_time, u_time, stime (starting > time > for Primetime, 08:00:00), etime (endtime for PrimeTime, 18:59:59). The function also > needs to remove downtime that occured on a public holiday and over weekends! Public > holidays will be read from mysql table with Datetime record of each public holiday.
- Flavio S. Glock
