how to compute for the downtime hours based on business days/hours
Posted on 2006-07-12
can anyone suggest a logic that i can use for the following specs:
downtime: 06-15-2006 08:00:00
fixed time: 07-25-2006 15:23:00
business days: monday - friday
business hours: 08:00:00 - 17:00:00
how do i get the downtime hours for the month of july taking into consideration the business days and business hours. so weekends and after office hours will not be included in the computation.
i would really really appreciate any ideas/thoughts on this one. i am giving all my available points. =)
regards and thanks in advance.