Post reply

Calculating Business Hours

  • June 24, 2002 at 2:28 pm

    #78971

    I am looking for a good function for calculating business hours between two creation datetimes. The function that I currently use takes twenty five minutes or more to process 150,000 records. I need to exclude weekends and holidays. Many thanks for a point in the right direction. BKloha

  • June 24, 2002 at 2:29 pm

    #431520

    I've done this, but populated a table with the valid business days. Then sum this up. Don't forget that holidays can be business or country specific, so accounting for this is hard without a table.

    Steve Jones

    steve@dkranch.net

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply