DateDiff question, need count for 8 hours a day including weekends and holidays
Posted on 2008-10-15
Should be pretty simple really, but I am in brainfart mode this am (pardon the expression), lack of caffeine again, I suppose...
I have two dates (startDate and endDate), they represent when a ticket is opened and closed. There will be a third field to be used later for 'workTime'.
For each day (24 hour period) in the dateDiff (including holidays and weekends), I need to add 8 hours, then when I have the final number, I need to subtract the value of the 'workTime' field.