Working w/ TimeStamp Calculation excluding Weekend

[rlsinning]

We have a database which Management wants to track by Time how long work sit in each Department

If Start Time is 6/20/2005 7:37 AM and Stop Time is 6/22/2005 7:37 AM then Wait Time should be 48 hours.

But If Start Time is 6/23/2005 7:37 AM and Stop Time is 6/27/2005 7:37 AM then Wait Time should be 48 hours after substracting 48 hours for the Weekend.

Also would be nice if Holidays were substracted, too

Examples:

Field: Start Time Format: TimeStamp

Field: Stop Time Format: TimeStamp

Field: Wait Time Format: Time

Any ideas ?

[RalphL]

See the 2 files posted here:

http://www.fmforums.com/threads/showflat...true#Post163758

They were for a shorter work day, but the modification should not be difficult. The calculations also account for holidays.

If you have questions about these files, I will try to answer them.

[Lee Smith]

Hi rlsinning,

Have you looked at the files by BobWeaver (Work Day Calculations) in the Sample File Area?

Search = [color:"blue"] Solutions & Suggestions >> Sample Files & Open Source Solutions

Keywords = [color:"blue"] +Work +Calculation

Weeks = [color:"blue"] 0

HTH

Lee