Results 1 to 2 of 2

Thread: Calculating Working Hours Between 2 dates

  1. Nov 19th, 1999, 03:15 PM #1
    mattbrown
    mattbrown is offline

    Thread Starter
    Addicted Member
    Join Date
    Aug 1999
    Location
    Hamilton, New Zealand
    Posts
    137

    Post

    I need to calculate the number of working hours between two dates. I think I have seen the code on here before. If somebody has it would they please be able to repost it.

    The two dates would be in DD/MM/YY HH/MM/SS format and working hours are defined as 8:30am to 5pm.

    Any help would be appreciated

    Thanks

    Matt Brown
    Reply With Quote Reply With Quote
  2. Nov 19th, 1999, 08:59 PM #2
    Guest

    Post

    Datediff("h",[date1], [date2])

    that will give the raw hours between the dates, youll have to remove non-working days, bank holidays, etc.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width