Reply to thread

Message: [QUOTE="jlclyde, post: 1213976"] I think I ahve part of it down now. Now I need to be able to subtract 13.5 hours if the two dates fall over a weekend. Pearsons formula works and assumes that all days are 19.5 hours long. On Fridays however we work 6 hours. So if a date falls over a weekend i need to subtract 13.5 hours. For instance my dates are 8-6-07 04:30 to 8-13-07 10:00. Pearson's formula says there are 103.5 hours. It shoudl be 90. I hoep this makes sense to someone. How do I get rid of those 13.5 hours? Thanks, Jay [/QUOTE]