Calculating Working Hours Between 2 dates

[mattbrown]

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

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

that will give the raw hours between the dates, youll have to remove non-working days, bank holidays, etc.