Results 1 to 10 of 10

VBA to calculate hours between 2 date/time excluding saturday & sunday

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-21-2008
    Location
    Hamilton, New Zealand
    MS-Off Ver
    Office 2007
    Posts
    255

    VBA to calculate hours between 2 date/time excluding saturday & sunday

    I need to calculate hours between a start date/time and an end date/time excluding saturday & sunday hours.
    The start may possibly start on a saturday or sunday and the end may possibly end on a saturday or sunday.
    But i only want the sum of weekday hours elapsed.

    eg 3/jun/2011 11:00:00 am to 8/jun/2011 9:00:00 am would = 70 hours
    eg 4/jun/2011 11:00:00 am to 8/jun/2011 9:00:00 am would = 57 hours
    eg 3/jun/2011 11:00:00 am to 5/jun/2011 9:00:00 am would = 13 hours

    Any help would be appreciated
    Last edited by wotadude; 06-09-2011 at 04:40 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1